MySQL Forums
Forum List  »  Microsoft Access

Comparing 2 Tables
Posted by: Ave
Date: August 02, 2004 05:03AM

Hi,

I'm looking for the correct sql syntax for the following problem.

I've got 2 different tables with 1 corressponding fieldname. I would like to retreive all records from table 1 without the records that exist in table 2.

For instance:
Table 1:
123 hello
234 world
345 hello again

Table 2:
123 This is an example

The result of the sql statement should be:
234 world
345 hello again

Thanks in advance!!

Options: ReplyQuote


Subject
Views
Written By
Posted
Comparing 2 Tables
3994
Ave
August 02, 2004 05:03AM
3350
August 02, 2004 08:42AM
2943
Ave
August 04, 2004 01:01AM
8400
March 14, 2005 10:58PM
3104
July 19, 2005 07:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.