Alle,
I�m having problems figuring how I should write the query(ies), or the CF
code to accomplish a >= count list. For example:
Table1:
T1-ID
T1-Data
Table2:
T2-ID
T1-ID
T2-Data
For each Table1 entry, I can have one or more Table2 entries.
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.
This one has me a little stumped�
Troy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
