This sort of functionality would be very useful for what we're trying to do, but I think someone told me that MySQL doesn't do this.
> Hi Andrew, > > That's correct, you need to run seperate queries first, then use QoQ to = > join them together. > > We use Oracle here, and we use DBLINK's between databases so we can run = > queries that join dta between DB servers.=20 > > For example: > > Say we have username details on one Database (or schema), and personal = > details on another Database (or schema), using a DATABASE LINK (or = > DBLINK), you can join the details together on the Database server without = > the need of having to run seperate queries beforehand. > > I create a DATABASE LINK in oracle named PERSONAL from the USERNAME = > database that points to another database storing personal details (refer = > to oracle documentation for more details on how to create DATABASE LINKS). = > I can create a SQL statement for use with cfquery like > > SELECT A.USERNAME, B.FIRSTNAME, B.LASTNAME > FROM USERNAMES A, [EMAIL PROTECTED] B > WHERE A.EMPLOYEE_NO =3D B.EMPLOYEE_NO > ORDER BY B.LASTNAME > > Oracle joins the data on the oracle server and returns a single resultset = > back (in our case, back to Coldfusion) > > I don't know if other Database servers have the same functionality, = > someone else may want to comment. > > Cheers, > Steve > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Stephen Bosworth > Application Development and Integration > Communication and Information Services > The University of Newcastle, Australia > Phone: 02 4921 6574 > Fax: 02 4921 7087 > Email: [EMAIL PROTECTED] > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --- 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
