Query Question

[james0816]

two tables...TableA and TableB. Both tables have the following common field names but not data: Field1, Name, Location

Field1 is unique so that there will be no duplicate values between tables.

I want to seach both tables for a value in Field1 and retrieve the Name and Location fields only from which ever table it is found in.

What is the easiest way to code this? So we'll say I am looking for a value of '0010398' that could be in either table.

Did that make sense?

 

[feherke]

Hi

[b]select[/b] field1,name,location [b]from[/b] table1 [b]where[/b] field1=[i]'0010398'[/i]
[b]union all[/b]
[b]select[/b] field1,name,location [b]from[/b] table2 [b]where[/b] field1=[i]'0010398'[/i]

[gray]-- or[/gray]

[b]select[/b] * [b]from[/b] (
  [b]select[/b] field1,name,location [b]from[/b] table1
  [b]union all[/b]
  [b]select[/b] field1,name,location [b]from[/b] table2 
) foo [b]where[/b] field1=[i]'0010398'[/i]

Feherke.

http://rootshell.be/~feherke/

 

[james0816]

thx..that's the way i had it. just thought there might be a better way.

 

[guelphdad]

you should have posted your join in your original question then. It would save someone typing up all the information you already had now wouldn't it?