Hi I've got a looping problem that is probably quite simple for most people but has me baffled
I have a list of allowed address types (Home, Shop, Head Office) A business can have 1 of each address type but may have 1,2 or 3 of them I want to find (for an individual business) what address types they have NOT got ie business has Home and Shop address type - I want to get just Head Office My tables are: tblAddressesAT (ID, AddressType) tblAddresses (AddressID, AddressType....) I think I have to loop thru tblAddresses then do a NOT IN select query for tblAddressesAT ... but that's when I get lost Any help at all would be greatly appreciated Seamus ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
