[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