Query & Column Display

From: <mrdjmagnet_at_aol.com>
Date: Thu, 22 Jan 2009 09:12:32 -0800 (PST)
Message-ID: <b487b6af-e8e7-4097-9759-a90b4c821a5f_at_v18g2000pro.googlegroups.com>

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

Original text of this message