You could use INNER JOINs if each table has a company ID for sure.
FROM company_table INNER JOIN slow_stream ON slow_stream.ID =
company_table.ID
INNER JOIN mesium_stream ON medium_stream.ID = company_table.ID
INNER JOIN fast_stream ON fast_stream.ID = company_table.ID
That should do it.
J.
John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer
www.red-omega.com <http://www.red-omega.com>
"Losing - If at first you don't succeed, failure may be your style."
~despair.com
-----Original Message-----
From: Darren Adams [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 9:09 AM
To: CF-Talk
Subject: SQL Joins.
Hello folks,
I ma having a spot of bother with joining tables in a query and could do
with some advice.
There are 4 tables: company_table, slow_stream, medium_stream and
fast_stream
Company table holds: company ID, name.
The other tables also have a company_name field.
I want to join all the tables together on the name field to give me one
virtual table.
What is the best way to go about this, I have tried in a number of ways.
Darren Adams
Web Developer
Marketing Department
Systems Union
Office: 01252 55 6220
Mobile: 07714 817 038
Email: [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists