[thelist] SQL Question
David Mitchell
dave at dbmdata.com
Wed Oct 29 14:17:40 CST 2003
Hi All,
Not sure the best way to go about this. Here is the scenario:
I have a "user" table with a field "NumUser" as the key.
I have another table with the fields "CreatedBy" and "ModifiedBy". Each
one of these fields will have a "NumUser" value in it (except that
ModifiedBy may be null). I am attempting to do a join across these 2
tables to get the FirstName and LastName values for the CreatedBy and
ModifiedBy values. Make sense?
Any advice is appreciated.
Dave
/**
David Mitchell
www.dbmdata.com
dave at dbmdata.com
*/
MortgagePro.ca - Now accepting online mortgage applications!
http://www.mortgagepro.ca
More information about the thelist
mailing list