Appreciate some suggestions on creating a query. -Retreiving records with a four digit id number. -Parent records end in '00' (i.e. 3100), child records end with '01' to '99' (i.e. 3102). -Need to exclude parent record if child record(s) exist. -return parent records if no child record(s).
In other words: If record id's are: 3100 3101 3102 3200 3300 Records 3101, 3102, 3200, 3300 are returned, but 3100 is not. Any ideas? Using MySQL 5 Thanks, Doug ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2757 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
