Re: Selecting all col of one table in a join

Yes, s.* is fine. If you're unsure of something like this the best thing to do is try it on a dev/test system. If you don't get a syntax error chances are it's okay. Mike. In article <340C1DD0.66F44E69@ultranet.com>, xtcpl <joep@ultranet.com> writes >I am trying to use one table as the criterior for the select by doing a >join. > >My thought was to do something like this. > >SELECT s.* >FROM strcustr s, appoehdr a >WHERE (s.cust_code = a.cust_code AND a.order_no = 444) OR > (s.cust_code = a.cust_code AND a.order_no = 454); > >This was the select statement for a test unload of our new tracking db. >My question is the s.* a valid statement? > >Joe > >----------------------------- >Joe Palladino >jpalladino@applix.com >Applix, INC. >112 Turnpike Rd >Westboro, MA 01581 >http://www.applix.com >----------------------------- -- Mik Hobbs