Re: Problem with selecting all col of one table in a join

xtcpl wrote: > > I am trying to do a select that of all of the columns in one table of a > join. > > SELECT s.* > FROM strcustr s, appoehdr a > WHERE (s.cust_code = a.cust_code AND a.order_no=3453) OR > (s.cust_code = a.cust_code AND a.order_no=3455); > > Is the s.* a legal statement or do I need to enumerate all of the > columns in strcustr? That's perfect. Your statement should work fine. You could make the SQL a little clearer, otherwise... To wit: SELECT s.* FROM strcustr s, appoehdr a WHERE s.cust_code = a.cust_code AND a.order_no in (3453, 3455); Art S. Kagel