Hello,
this sql statement works in v5, but it doesn't work in v3. what can I do to make it work in V3 OR is there a command I can use in V3 that gives me the same result?

SELECT BROKERS.AG_ID, ALLTRIM(BROKERS.AG_NAME) AS AG_NAME,;
ALLTRIM(BROKERS.AG_STREET) AS AG_STREET, ALLTRIM;
(BROKERS.AG_STREET2) AS AG_STREET2, ALLTRIM;
(BROKERS.AG_CITY) AS AG_CITY, BROKERS.AG_STATE, ;
BROKERS.AG_ZIPCODE, BROKERS.EOEXPDATE,IIF(ISNULL;
(CONTACTS.PRETITLE), "NO REC", CONTACTS.PRETITLE);
AS PRETITLE FROM BROKERS LEFT OUTER JOIN CONTACTS ;
ON ( BROKERS.AG_ID = CONTACTS.AG_ID ) into cursor temp
thanks.
sherry