June 8, 2004 at 6:18 pm
The following displays just "Jane Doe",
however I want it to display all customers
and then their passwords if they have one
SELECT customers.number, customers.name, xref.details
FROM customers LEFT OUTER JOIN
xref ON customers.number = xref.number
WHERE (xref.type = 'pass')
------------------------------------------
The following displays all customers,
however it makes the password column identical for
both which is wrong since John Doe password = blank
SELECT customers.number, customers.name, xref.details
FROM customers LEFT OUTER JOIN
xref ON customers.number >= xref.number
WHERE (xref.type = 'pass')
------------------------------------------
Please let me know if you want me to email
the 100k MDB file to you for testing purposes.
CUSTOMER dataset
number name
1 Jane Doe
2 John Doe
XREF dataset
number type details
1 email 126@a.com
1 pass goodfood
2 email 42@e.com
------------------------------------------
End Result that I need:
number name details
1 Jane Doe goodfood
2 John Doe
June 8, 2004 at 6:24 pm
See/leave responses in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=119979&app=true
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply