Another question!

[Guest_imported]

I have managed to retreive data from both tables where details.USER = notes.USER.

This is fine as now users appear with the note corresponding to themseleves, BUT!! if a user does not have a note, they do not appear in the notes table and therefore details.USER does not = notes.USER and I get a message stating no records found.

The SQL I am using is:

sqltemp="select * from details,notes where details.USER = notes.USER and details.USER = '" sqltemp=sqltemp & myname & "'"

Please help!!!

 

[ghubbell]

Hi Mark,
Somewhere in your computer you will find the Northwinds sample database. If you can find it, open a new query in SQL view and paste in:

SELECT Orders.*, [Order Details].ProductID
FROM Orders LEFT JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID;

Results here with "Left Join" are "show me all the records from the orders table and I don't care if there are any details in the order details table."

Check it out and do a few tests to see some results.

Gord
ghubbell@total.net