Antti Linno <[EMAIL PROTECTED]> writes:
>> I think, the following select will solve your problem
>>
>> select first.id
>> from first
>> except
>> second.id_first
>> from second;
>>
> Nay, I got parse error.
Should be ... EXCEPT SELECT second.id_first ...
Anyway, we should have full ANSI join
Try this:
> Nay, I got parse error.
> Antti
select first.id
from first
except
select second.id_first
from second;
Greetings,
Mikolaj.
Antti Linno wrote:
>
> > I think, the following select will solve your problem
> >
> > select first.id
> > from first
> > except
> > second.id_first
> > from second;
> >
> Nay, I got parse error.
'select' is missing after 'except'.
select first.id
from first
except
select second.id_firs
> I think, the following select will solve your problem
>
> select first.id
> from first
> except
> second.id_first
> from second;
>
Nay, I got parse error.
Antti
Antti Linno wrote:
> Greetings.
> I have a problem. I have 2 tables. E.g. work and workers. I want to
> select records, that 1st table has, and the second hasn't(both have id
> attribute). I mean I can't do it with is NULL, because those records don't
> exist. I was shown, how it is done with my
Greetings.
I have a problem. I have 2 tables. E.g. work and workers. I want to
select records, that 1st table has, and the second hasn't(both have id
attribute). I mean I can't do it with is NULL, because those records don't
exist. I was shown, how it is done with mysql
select first.id,second.id
