It's possible with a single query if you use an UDF to create 'Revisions' column.
>I have two tables as follows (not all fields listed):
>
>Table 1
>DrwNo Lastrev .........
>100 B
>101 C
>102 D
>etc....
>
>
>Table 2
>DrwNo Revno .....
>100 0
>100 A
>100 B
>101 0
>101 A
>101 B
>101 C
>etc...
>
>
>What I would like to produce is the following cursor:
>
>
>Drwno Revisions
>100 '0, A, B'
>101 '0, A, B, C'
>102 '0, A, B, C, D'
>
>
>Is this possible with a single SQL statement? If so, can someone please point me in the right direction.
>
>Thanks,
--sb--