> Just to clarify what was intended in that post: > > > > Can Query Of Queries be performed on tables from different datasources > =3F > > > > I would say "no". Only between joins with other existing queries.
Bugger. That's what I was afraid of. > Of course, if your queries come from different tables in different > databases and then you perform a QofQ on those existing queries you have > effectively joined the data from different databases. Yep. Queries of Queries of Queries of .......... That's what I expected to have to do, but wanted to check first if there was a less longwinded way. > I have not tested this, but I think that CFMX would only assume you are > JOINing to queries and would not care where the data came from. > > Remember though, that QofQ is not an optimised SQL engine and this will > involve full scans of the data. Yes. Again, I'm assuming every time you add an extra query and an extra level that there'd be a commensurate loss of performance. So I'll do all I can about getting the tables into the same datasource. > Gary Menzel > Web Development Manager > IT Operations Brisbane -+- ABN AMRO Morgans Limited --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
