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,