From -HEAD: ERROR: aggregates not allowed in WHERE clause STATEMENT: SELECT * FROM loans l WHERE id IN ( SELECT max(l.id) FROM loansJOIN customers c ON c.id = l.customer_id JOIN people p ON p.id = c.person_id
WHERE p.first_name = 'Test person' GROUP BY l.loan_type_cd ) ;
The real issue is this: ERROR: missing FROM-clause entry for table "l" at character 132 STATEMENT: SELECT max(l.id) FROM loansJOIN customers c ON c.id = l.customer_id JOIN people p ON p.id = c.person_id WHERE p.first_name = 'Test person'
GROUP BY l.loan_type_cd;And if I change the FROM loans to be FROM loans l, the original select does work fine.
Let me know if I need to create a full test case for this... -- Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature