Steven,

Is revision a separate filed? If it's, you have to add it to JOIN condition.

LEFT JOIN table2 t2 ON t2.did = t1.did ;
       AND t2.rev = t1.rev ;

>Sergey,
>
>This is close but the canceled column is coming up all .T. when in fact only one revision 'B' was canceled. However there is only one record showing up for the 'B' revision. Should show
>
>854407 A //
>854470 B //
>854470 B 04/03/03
>854407 C //
>etc