Re: query to find references

Regarding my question on a query to find rows in table A to which less that a certain number of rows in a table B refer: I also want those rows in A to which ZERO rows in B refer! This complicates a solution using GROUP BY in a sub-query, I think.

Thanks again for any help,
Michiel

-- 
Michiel Perdeck


------------------------------------------------------------------------

Siemens Nixdorf: perdeck.via_at_sni.de     +31 70 3331530   fax: 3331320
CMG AT Finance : michiel.perdeck_at_cmg.nl +31 20 5033000   fax: 5033011
private        : michiel.perdeck_at_tip.nl +31 30 6570818 pager: 0659676940


------------------------------------------------------------------------