Query & Column Display

I did this once before a long time ago, but cannot remember how.

Say I have 2 tables. I query table #1, and if the value I am looking for is not there, then get the value from table 2.

Both tables have the same primary key, so they must be joined. I remember this was NOT a lot of code with subselects and all that jazz. But I cannot recall how it was done.

Was looking at analytical stuff for this, but no luck yet......

Thanks! Received on Thu Jan 22 2009 - 11:12:32 CST