It's not orthodox, but Russ's solution is actually easier to manage esp. if your not a SQL engineer.
BTW, Tim, didn't you forget the group by clause? Paolo > -----Original Message----- > From: Tim Blair [mailto:[EMAIL PROTECTED]] > Sent: 19 September 2002 13:37 > To: [EMAIL PROTECTED] > 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] > -- ** 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]
