I don't think that's possible (at least not in a single SQL Statement). If you want this result for display purposes you could use a hierarchical flex grid to display it. Although you would probably need an ADO shaped recordset as a data source.

>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!