Re: How to list rows violating constraints, from the exceptions table

Christian Bjerregård wrote:
>
> Anybody out there who knows a good way to get a printout of
> the rows in tables that violate a foreign key constraint,
> and therefore are represented in an exceptions table with
> it rowid.
>
> chbj_at_novo.dk

How about:

select a.*
from tablea a, exceptions_table b

where  a.rowid = b.row_id          -- must use column row_id not rowid
                                   -- otherwise get error

--
Anne Crowther
mailto:adf0049_at_ggr.co.uk