In a forum app, I have a table of messages that I'm going to query for
display. A field in that table is called "UserID". Everywhere that "UserID"
is not "0", I'd like to query another table for that person's user info.
Q:
Is this something I could do all in one query, or should I do the first part
as one query and then worry about a second query where necessary while I'm
outputting the first one ..
I'm not sure if this calls for a JOIN, a Left JOIN, a UNION or what ...
Any ideas?
Thanks
-Russ
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
