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.