As far as I know, this isn't possible. What is possible is doing two
seperate queries and making your own dataset with either QueryNew() or
building a structure. Can you give us some more information?
Sharon
- Original Message -
From: "Robert Everland" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 2002 11:15 AM
Subject: Join up datasources
> Is it possible to have a query where you don't specify a datasource
> and then inside of the query join up more than one datasource. Something
> like this
>
>
> Select DSN.Database.Table.Row,
> differentdsn.database.table.row
> From dsn.database.table,
> differentdsn.database.table
>
>
>
> Robert Everland III
> Dixon Ticonderoga
> Web Developer Extraordinaire
>
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists