Hello everyone,
Here is my case: I have two tables

Master Table:
ID MemberID info
1 1 This guy is cool
2 4 This guy is rude
3 This record has no MemberID
4 3 This one's hot

Member Table:
MemberID Fname Lname
1 Joe Smith
2 Scott Monsion
3 Amy Wilms
4 Dan Lee

When i use inner join such as ==>> SELECT
Master.MemberID,Member.Fname,Member.Lname,Master.i nfo FROM Member INNER
JOIN Master ON Member.MemberID=Master.MemberId
My results are like:

MemberID Fname Lname info
1 Joe Smith This guy is cool
4 Dan Lee This is rude
3 Amy Wilms This one's hot

IT IS LEAVING OUT THE RECORD WHICH DIDN'T CONTAIN A MemberID IN Master
TABLE. Could someone please tell me how this could be fixed. Thank you
so much in advance for your help.

Jimmy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Jimmy,

Replace INNER with LEFT.

An INNER JOIN will return only matching records in both tables.

The LEFT JOIN will return all records in the left table (Member in this
case) and any matching records (or nulls) for the right table (Master in
this case).

I believe this will work.
-----------------------------------------------------
SELECT Master.MemberID,
Member.Fname,
Member.Lname,
Master.info
FROM Member LEFT JOIN Master ON Member.MemberID=Master.MemberId

-----------------------------------------------------

Hope this helps,
John MacIntyre
VC++ / VB / ASP / Database Developer
http://www.johnmacintyre.ca


"Jimmy Tran" <hunganh20 (AT) yahoo (DOT) com> wrote