one query to tell if a value exists in one of two tables?

[lemkepf]

Hello SQL gods, once again i'm in need of some help.
I have 2 tables. One holds old and discontinued values, one holds new values(the values can't be in both).

I need to write a single select query (more like an existence test) that will return true if the value is in one of the two tables. Can this be done?

Thanks for all your help!
Paul

 

[BuGlen]

You can use a union query to gather records from 2 or more tables. For example:

select value1 from table1 where value1 = 'condition'
union all
select value1 from table2 where value1 = 'condition'

Then check the record count to see if the value exists.

Hope this helps.

Glen Appleton

VB.Net student.