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

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

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