May 16, 2015 at 10:20 AM

Logic Miss

33 Views

hi

Experts

could help me in this query

The Bellow Querys are separately working but when i Combined it's not Executed...

SELECT distinct T3.[U_E360_Sln], T3.[U_E360_Bdn],(select (sum(a.[LineTotal])) FROM OPCH T2 INNER JOIN PCH1 a ON T2.DocEntry = a.DocEntry INNER JOIN OCRD T4 ON T2.CardCode = T4.CardCode WHERE a.[U_E360_Sln]='[%0]' and a.[TargetType] !='19' and T4.[GroupCode] <> '5' and T4.[GroupCode] <>'101' ) as TOTAL

FROM OPCH T2 INNER JOIN PCH1 T3 ON T2.DocEntry = T3.DocEntry INNER JOIN OCRD T4 ON T2.CardCode = T4.CardCode WHERE T3.[U_E360_Sln]=[%0] and T3.[TargetType] !='19' and T4.[GroupCode] <> '5' and T4.[GroupCode] <>'101'

Union

SELECT sum(T1.[U_Qty]) "Total Qty" FROM [dbo].[@E360_EXEMB] T0 inner join [dbo].[@E360_EXEMBC] T1 on T0.[DocEntry]= T1.[DocEntry] WHERE T0.[U_PrjName]=[%1] and T1.[U_Slno] =[%0] GROUP BY T1.[U_Qty]

Thanks for Advance Help

----AKR