Subject | Re: [ib-support] is it possible to.... |
---|---|
Author | Svein Erling Tysvær |
Post date | 2002-02-12T09:48:48Z |
Hi Bert,
misunderstood something ;o}
SELECT * (or better, a list of fields)
FROM A
WHERE NOT EXISTS (SELECT 1 FROM B WHERE B.A_PK = A.PK)
Was this what you were looking for?
Set
>return a selection of rows from table A based on wether the value of thethis sounds like a very clear and simple question, so I must have
>primary key of a row isn't found in a certain column in table B. (or is
>found)? if yes : how?
misunderstood something ;o}
SELECT * (or better, a list of fields)
FROM A
WHERE NOT EXISTS (SELECT 1 FROM B WHERE B.A_PK = A.PK)
Was this what you were looking for?
Set