Share
Report
130dear Victoria,
I have a problem with a view that I have written, could you please help me with it?
I have TABLE1 that contains the following data (SP means SALESPERSON):
SP Qty
------------
A.T 10
C.C 20
E.A 40
C.G 3
And TABLE2 that contains the following:
SP Qty
---
A.T 1
C.C 50
C.G 80
I believe that if I perform a full outer join E.A will appear in my query's result.
but, in fact, I am trying to execute the following query:
select A.SP, (A.QTY - B.QTY) as 'QTY'
FROM TABLE1 A FULL OUTER JOIN TABLE2 B
ON A.SP = B.SP
and the problem is that I am not getting in my result any row for the salesperson E.A.
how can I force it to show me E.A with 40 as a QTY (as if I was making 40 - 0 = 40)?
any help would be more than appreciated
thank you in advance
*This post is locked for comments
All responses (
Answers (
