Re: CONSTRUCT with multible tables?

> let sql_var="select * from clnt,clnt_contact where ",where_clause, > " and clnt_contact.clnt_nmbr = clnt.clnt_nmbr" > > This is inconsistant in it's selection. An additional problem is that I > want to select the client record, and the contact record, but if a > contact record is not present, I still want the client record anyway. > Harry Skelton - 1848 Beaver Dam Lane - Marietta, Georgia - 30062 Harry, You don't say how it is inconsistent so it is difficult to say why it is not working for you. (If that was your description to support, you could wait a very long time!! :-)). As for the other try an outer join (Eg. from clnt, outer clnt_contact). This will pick up clnt rows where no contact rows exists. But, depending on the query parameters entered for clnt_contact attributes through the construct, it may not always give you the results you expect. Unfortunately the results probably will match the relational query rules! Cheers - Jim My opinions are my own. They may vary with time but they remain MINE! ---------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 375-5222 (Work) Address: 700 Airport Blvd. #300 (415) 775-7762 (Home) Burlingame, CA 94010-1937 Fax: (415) 375-5019 ----------------------------------------------------------------------