Hi, I am trying to create summary from three data tables. How can i achieve the same.
Any help would be much appreciated.
Thanks in advance.
Hi, I am trying to create summary from three data tables. How can i achieve the same.
Any help would be much appreciated.
Thanks in advance.
Use inner joins on t1 and t3 and say this is t4
Then t2 left join with t4.
You get your output without total and add column qty to it with 1 as value
To get total use linq query to find sum groupby po number to get total of qty