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