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


HTH

Woody (TMW)