[EMAIL PROTECTED] schreef:
> SELECT EMPNO FROM EMP WHERE EMPNO NOT IN ( SELECT EMPNO
> FROM [EMAIL PROTECTED] )
Or maybe use something like
select EMPNO as E1 from EMP left join [EMAIL PROTECTED] as E2 on E1.EMPNO =
E2.EMPNO where E2.EMPNO IS NULL
(untested)
> So search FILE1 for all line entri
Just an idea, don't know whether it's useful...
If you can get both files sorted (either by adding order to your sql
query that generates the file, or the commandline 'sort') the problem
becomes much more easy.
You'd just have to traverse each file, something like this:
read word_1 from file_1
rea
[EMAIL PROTECTED] wrote:
>
> I have two database tables, one is local and one is on a WAN. They are
> supposed to be in-sync but they at the moment, they are not. There are
> 8million+ plus rows on this table.
>
> I tried to do SELECT EMPNO FROM EMP WHERE EMPNO NOT IN ( SELECT EMPNO FROM
> [EMAIL
On 08/16/2006 04:35 PM, [EMAIL PROTECTED] wrote:
Hi all,
I have two database tables, one is local and one is on a WAN. They are supposed
to be in-sync but they at the moment, they are not. There are 8million+ plus
rows on this table.
I tried to do SELECT EMPNO FROM EMP WHERE EMPNO NOT IN ( SELE
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi all,
Hello,
>
> I have two database tables, one is local and one is on a WAN. They are
> supposed
> to be in-sync but they at the moment, they are not. There are 8million+
> plus
> rows on this table.
>
> I tried to do SELECT EM
