Hello guys, i have two table like blue area and green area.
Table1: ID1 and ID2 are primary key.
Table2: ID3 is primary key.
How to get result like yellow area.
Hello guys, i have two table like blue area and green area.
Table1: ID1 and ID2 are primary key.
Table2: ID3 is primary key.
How to get result like yellow area.
hi
please explain how you are joining !!! the two tables !!!
blue green
doing it is easy .. !!! IN OUT has to be transposed
using
SUM( case when IN
SUM( case when OUT
is the data you have put CORRECT !!!
DDL, sample data in easily consumable scripts and expected results will help everyone out
Notice your last post. Pivot Table, SQL Server 2008 R2