[thelist] table join for 4 tables

[Joshua Olson]

> -----Original Message-----
> From: Peter Brunone (EasyListBox.com)
> Sent: Thursday, November 03, 2005 1:09 PM
> 
> If they're all inner joins, how about just saying
> 
> SELECT table1.status, table2.field1, table2.field3, etc.
> WHERE table1.status = 10
> AND table1.Personid = table2.Personid
> AND table1.shippingid = table3.shipppingid
> etc.

A couple reasons come to mind..

1.  You don't have a FROM clause--your query won't work.  I presume this is
a typo.  :-)

2.  If you are suggesting a FROM clause such as FROM table1, table2, table3,
etc, then you are using a less useful (and NOT of best practice) syntax.

<><><><><><><><><><>
Joshua L. Olson
WAE Tech Inc.
http://www.waetech.com/
Phone: 706.210.0168 
Fax: 413.812.4864

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/