Re: How to select records not present in either two similar tables

Article View: borland.public.interbase.sql

Article #461

Back to borland.public.interbase.sql Previous Next

#461

From: Monalee Bhandge
Date: Sun, 25 Nov 2007 07:11

14 lines
1418 bytes

"Leonardo Tansini" <ltansini@katamail.com> wrote:
>In my IB db I've two big employees tables whith the same structure and  
>keys. I need to create a query to select the employees present in the  
>first table that are not present in the second one. Some help? Regards.

ANS--->
    suppose first table name is emp1 & second one is emp2 then you query should be like---------

SELECT  emp1.emp_name, emp1.address FROM emp1, emp2
WHERE emp1.emp_id=emp2.emp_id;

It's too simple.
Thanks.

Technical Details

Message-ID: <47492e25$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <op.t13wz0jinnuxdn@salaxp>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,69fa63958f1f7eb3
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Monalee Bhandge" <monaleeb@gmail.com>
Sender: "Monalee Bhandge" <monaleeb@gmail.com>
Reply-To: "Monalee Bhandge" <monaleeb@gmail.com>
Subject: Re: How to select records not present in either two similar tables
Newsgroups: borland.public.interbase.sql
X-User-Info: 203.212.197.223     
References:  <op.t13wz0jinnuxdn@salaxp>
NNTP-Posting-Host: 207.105.83.66
Message-ID: <47492e25$1@newsgroups.borland.com>
Date: 25 Nov 2007 00:11:17 -0700
X-Trace: newsgroups.borland.com 1195978277 207.105.83.66 (25 Nov 2007 00:11:17 -0700)
Lines: 14
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message