>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?
If it's not broken, fix it until it is.
My Blog