From: "Jason Dodson" <jasond@...>

> Woody (TMW) wrote:
> > From: "Joe Martinez" <joe@...>
> >
> >>Here's what I wish was possible... I want to grab ALL the fields in one
> >>table, and only a couple of fields in a joined or subselected
> >>table. Something like:
> >>
> >>Select * from sales, custfname,custlname from customers...
> >>
> >
> >
> > Select a.*, b.FieldOne from TableA a, TableB b
> > where a.SomeField = b.SomeField
> >
>
> Joining that way will get you shot... or worse.

The question was about selecting all fields from one table and only some
from another, not how to go about the best join syntax. When that question
is asked, a different answer might come out. Also, different joins work
depending on how or what you want out of a query. If you want to lock
yourself into one mode of thinking, well, you have that right.

Woody (TMW)