I got this problem where I need to look up values in two columns from
another table.
I can get OUTER LEFT JOIN working when looking up one column from a table
but when looking up at two columns from a table I can't get the SQL syntax
correct.
The scenario is
A table has definitions for abbreviation of initials. From my search query
there are two columns of initials, I am having problems in writing an SQL
statement to look up and replace both columns of initials with their
correct definitions. I was using an OUTER LEFT JOIN statement
I am sorry if this isnt the correct Newsgroup to post this.