Results 1 to 2 of 2

Thread: DB query

  1. #1
    Join Date
    Mar 2007
    Posts
    1

    Unanswered: DB query

    Table names and their field names
    members
    field name:-memberId firstname lastname username password

    membertype
    field name:-membertypeid membertypename

    membertyperequest
    field name:-memberId membertypeid

    member_assign
    field name:-memberId membertypeid

    A new member will register, when he registers he can choose membertype(optional). Admin will see the request type and assing membertype.

    The problem is, how to get values from members and membertyperequest (if they have not choosen one)?
    Last edited by parasuramank; 03-06-07 at 08:37. Reason: Correction

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    with a LEFT OUTER JOIN
    Code:
    select members.memberId
         , members.firstname 
         , members.lastname
         , membertyperequest.membertypeid as requested_type
      from members
    left outer
      join membertyperequest
        on membertyperequest.memberId = members.memberId
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •