QUERY TWO TABLES PROBLEM

[seg101]

I am having a problem with querying two tables!

I have two tables, say table_one and table_two. These two tables have a similar field, say table_one.field and table_two.field.

I wish to select all of the table_two records appart from the ones where table_two.field = table_one.field.

For example if table_one.field held the following records:

item1
item6
item19

and table_two.field held:

item1
item4
item6
item9
item16
item19

I would expect the output of the SQL query to be:

item4
item9
item16

I would be very greatfull if someone could please advise me.

Sam

 

[cwong1]

Try this:

SELECT table_two.fields FROM table_two LEFT JOIN table_one ON table_one.fields=table_two.fields WHERE table_one.fields IS NULL ;

 

[seg101]

Thanks, but this just appears to return the empty set...

 

[parkers]

the required should simply be:

SELECT * FROM table_one, table_two WHERE table_one.field != table_two.field;

try this...

 

[parkers]

... sorry the above is wrong just re-read your initial entry... I'll have a re-think !

 

[parkers]

... i should also have said that the above my query is only OK if table_two contains all of the same AND different entries to table_one.