General information
Category:
Coding, syntax & commands
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!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only