Hmm. Got a syntax error on the first line.
Here's my table layout as an example:
Table 1: COMPANY
companynam C,30
ckey N,7
Table 2: DIVISION
div_name C,50
ckey N,7
Say table COMPANY has only 1 record and table DIVISION has 3 records. How can I create a cursor using SQL only to create 3 records with the field companynam being filled for the first record and not for the other two?
Thanks!