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.upscene.com
> 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
> ------------------------------------------------------------------------
> ---------
> Company_ID | Company_Location | Company_State | Company_area_code |
> Company_Prefix
