Multiple queries may be faster. See http://www.craigberntson.com/Articles/kb004.htm


>I have a select statement as such:
>

>SELECT CLIENTNM.DISTRICT, ADDRES.STATE, ALIASES.NAME_ALIAS, ;
>  CLNTREF.REF_COD, CR_HIST.VDATE, CUSTOMER.CR_RATING, PRODUCTS.DEDNT ;
> FROM CLIENTNM, ADDRES, ALIASES, CLNTREF, CR_HIST, CUSTOMER, PRODUCTS, ;
>    CONTACT ;
>  WHERE CLIENTNM.IDCLIENT = ADDRES.IDCLIENT AND ;
>    ADDRES.ADDRESS_TY = "MN" AND ;
>    CLIENTNM.IDCLIENT = ALIASES.IDCLIENT AND ;
>    ALIASES.ALIAS_TYPE = "MAIN" AND ;
>    CLIENTNM.IDCLIENT = CUSTOMER.IDCLIENT AND ;
>    CLIENTNM.IDCLIENT = PRODUCTS.IDCLIENT AND ;
>    CLIENTNM.IDCLIENT = CR_HIST.IDCLIENT AND ;
>    CLIENTNM.IDCLIENT = CONTACT.IDCLIENT AND ;
>    CLIENTNM.IDCLIENT = CLNTREF.IDCLIENT AND ;
>    CONTACT.CONTACT_ID = CLNTREF.CONTACT_ID ;
>  ORDER BY 1 DESC ;
>  INTO TABLE CLNTSHAWNA.DBF
>

>but the result table brings up multiple instances of any client where there are 2 or more records in cr_hist and/or clntref. I want the latest date for the cr_hist.vdate for each client and just one record from the clntref for the client.
>
>Would it be easier to do several select statements to get this infor, or can someone show me the way to do it for one select statement.
>
>Thanks in Advance.
>Beth