Please
use ctrl-c ctrl-v to post code; I presume the :1 bit is a misprint.
What goes wrong with your query? Apart from using A and C for the same table and not writing "FROM A AS C", which looks very strange indeed, that is?
Have you tried a JOIN on DOCNO? Or even from A, B USING (DOCNO)?
[edit]Add: Please use more informative
subjects than "Need help with this query."[/edit]
[ October 07, 2008: Message edited by: Campbell Ritchie ]