Select filedname from two tables

sandy1028

I have to 3 tables Table1,table2,table3 and in all tables field name fieldname is similar .

I have to select values from table1 the values which is not in table2 and table3.

Select distinct(fieldname) from table1 where fieldname not in (select distinct(fieldname) from table2 union (select distinct(fieldname) from table3)

But I am gtting the proper result

bogu

sandy1028 wrote:
But I am gtting the proper result

And you don't want to get the proper result? 🙂

sandy1028

bogu wrote:
And you don't want to get the proper result? 🙂

Sorry I am not getting the proper result

Roger_Ramjet

If that is your real query then you gave a syntax error

Select distinct(fieldname) from table1 where fieldname not in (select distinct(fieldname) from table2 union[COLOR="Red"] ([/COLOR]select distinct(fieldname) from table3)

A more efficient way of doing this

Select distinct(fieldname) from table1 LEFT JOIN (select distinct(fieldname) from table2 union select distinct(fieldname) from table3) AS t2 ON table1.fieldname = t2.fieldname WHERE t2.fieldname IS NULL