>What I need to do is create a list of those Table1 entries that have a >= X
number of Table2 entries (where X is variable). I don't need Table2's data,
just Table1's.
Something like
SELECT T1.T1_ID, COUNT(T2_ID)
FROM T1, T2
WHERE T1.T1_ID = T2.T1_ID
GROUP BY T1.T1_ID
HAVING COUNT(T2_ID) >= #whatever#
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
