Re: Tough Query for this New DBA

2004-03-21 Thread Peter Brawley
=#; ? PB - Original Message - From: Duke, Brian To: [EMAIL PROTECTED] Sent: Sunday, March 21, 2004 3:16 AM Subject: Tough Query for this New DBA There has got to be a better way for me to query/subquery this data. I have 4 tables. Table1

Re: Tough Query for this New DBA

2004-03-21 Thread Martijn Tonies
Hi Brian, Not answering your question, but are your table names really "table1", "table2" etc? If so, you will be running into more problems :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscen

Tough Query for this New DBA

2004-03-21 Thread Duke, Brian
There has got to be a better way for me to query/subquery this data. I have 4 tables. Table1 - Company_Name | Company_ID - Blue Shoe| 101 Fast Cow | 102 Table2 ---