I am encountering problems with IN selections. I am trying this query :
delete from status where status_id not in (select distinct status_id from company); "status_id" is a foreign key in "company". It does not delete any records from status table whereas it should because the sub query returns some records. Any explanation ? Thanks -- M. Jérôme CALAIS (Ingénieur Conseil) Portable: 0620648297 E-Mail: [EMAIL PROTECTED] ------------------------------ Arunix Z.A.L St Amé 62806 Liévin Cedex France Tel: 0321142843 Fax: 0321142831 URL: http://www.arunix.fr ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
