Very nice. Thank you. ----- Original Message ----- From: Tim Blair To: [EMAIL PROTECTED] Sent: Thursday, September 19, 2002 2:36 PM Subject: RE: [ cf-dev ] SQL question - brain a blank!
> how about > > select (select count(ID) from PeopleCars where peopleID = > #ID#) AS countcars, > (select cound(ID) from PeopleBoats where peopleID = > #ID#) AS countboats, > (select count(ID) from PeopleHouses where peopleID = > #ID#) AS counthouses, people.name from people where peopleID = #ID# > Eugh. :o\ ;o) ------------------------------------------------------- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 ------------------------------------------------------- rawnet ltd Atrium Court Bracknell [EMAIL PROTECTED] Berkshire Tel : +44 (0) 1344 393 040 RG12 1BW, UK http://www.rawnet.com ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. ------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
