how to do something with left join

[inhahe]

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 if it matches something. as in: or (users.username=='something' and users.id=quotes.sbuserid)

 

[r937]

which field? which table? could you please show the entire query?

r937.com | rudy.ca