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

Is it for VFP or SQL Server - if the later, then it's easy (though depends on your SQL Server version), if the former, you can do this with UDF (same way as in SQL Server 2000), but do you want to go this route?