Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to do something with left join
i have two tables with one field name in common, if i do a left join on them that field is 'none' wherever the right table has no record, and i want that field to be the left table's value. no idea how to do it. all i really want to do with the right table is look up a certain value and see...
