query syntax

[connections cardiff]

hi all,

could someone convert english->MySQL please?

show me all the records in database1.table1 where there is no
corresponding record in database1.table2 comparing by fieldx

to recap:

so we are wanting to bring up the records of one table where there is
no match in another table based on a particular field..

I genuinely appreciate your help.

s

[Mark Rance]

"connections cardiff" <[e-mail]> wrote in message
news:69**************************@posting.google.c om...

hi all,

could someone convert english->MySQL please?

show me all the records in database1.table1 where there is no
corresponding record in database1.table2 comparing by fieldx

This might not be the most efficient query but should work

SELECT table1.fieldx FROM table1 WHERE table1.fieldx NOT IN
(SELECT table2.fieldx from table2 WHERE table1.fieldx = table2.fieldx);

-Mark

[Mark Rance]

"connections cardiff" <[e-mail]> wrote in message
news:69**************************@posting.google.c om...

hi all,

could someone convert english->MySQL please?

show me all the records in database1.table1 where there is no
corresponding record in database1.table2 comparing by fieldx

This might not be the most efficient query but should work

SELECT table1.fieldx FROM table1 WHERE table1.fieldx NOT IN
(SELECT table2.fieldx from table2 WHERE table1.fieldx = table2.fieldx);

-Mark

[Mark Rance]

"connections cardiff" <[e-mail]> wrote in message
news:69**************************@posting.google.c om...

hi all,

could someone convert english->MySQL please?

show me all the records in database1.table1 where there is no
corresponding record in database1.table2 comparing by fieldx

This might not be the most efficient query but should work

SELECT table1.fieldx FROM table1 WHERE table1.fieldx NOT IN
(SELECT table2.fieldx from table2 WHERE table1.fieldx = table2.fieldx);

-Mark