Joe hat gewuenscht:

<<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...>>


Isn't it? Using:

Select * from sales S, C.custfname, C.custlname from customers C

And/Or

Select S.* from sales S, C.custfname, C.custlname from customers C

?

Clay Shannon,
Dimension 4 Software