Hi Cindy & Trey,

Thanks for the help. I was able to get the results I wanted and here is the final sql that gets me there.

select health.comp_no, health.item_no, health.date_serv, health.descript, health.detail, health.rx, master.name, master.brand_no from health left join master on health.comp_no = master.comp_no where master.location <> " " order by
health.comp_no into table healthtemp nofilter

As always you fine people at the U.T. have made my day again.

Jim Harvey
jharvey@netrax.net


>James,
>
>

SELECT Table1.*, Table2.Name ;
>    FROM Table1 LEFT JOIN Table2 ;
>    ON Table1.Comp_no = Table2.Comp_no ;
>    INTO CURSOR TableTemp

>This will give you all records in Table1. The ones with a match in Table2 will have the Name filled in, the others will have .NULL. in that field. If you don't want the nulls, you can use NVL(Table2.Name, SPACE(30)) AS Name.
>
>Another way is to use:
>

SELECT Table1.*, ;
>    LOOKUP(Table2.Name, Table1.Comp_no, Table2.Comp_no, [Comp_no]) ;
>    FROM Table1 ;
>    INTO CURSOR TableTemp

>
>>Hi All,
>>
>>I'm trying to create a cursor but keep getting a 'cartesian' join.
>>
>>Table1 has 96,000 + records.
>>
>>table2 has 24,000 + records.
>>
>>I want all the records in table one and I'm only looking for the data in a specific field of table2.
>>
>>The resultant table should include all the fields in table1 and only the table2.name field information.
>>
>>The comparable field in both tables is the comp_no field.
>>
>>Here's one of many miserable attempts.
>>
>>select tabel1.*, table2.name from table1, table2 where table1.comp_no = table2.comp_no into cursor tabletemp
>>
>>The above gives me 800,000 + records, I only want table1 records with the name field incorporated.
>>
>>I'd appreciate any help, guidance.
>>
>>TIA.
>>
>>Jim Harvey
>>jharvey@netrax.net