Posted by alomrani on 11/29/05 10:28
Hi all,
I encountered this small problem
I have two tables A and B with two columns 1 and 2 each, I would like
the first column of each table when match the first in the second table
is to subtract the second column
so the result would look as follows
Column 1 | Columnn 2
where A1=B1 | A2-B2
Now this is no problem so far ..
But if there was no corresponding value in column 1 in either tables ..
i.e. field A1 doesnt exist in Table B column 1, IT SHALL DO A2 - 0; or
0-B2 ..
NOW How can that be achieved ?
Thanks all for your help
Navigation:
[Reply to this message]
|