Skip to Content
0
Former Member
Jan 09, 2012 at 06:25 AM

Query Help

19 Views

Hi Friends,

I want your help for Join following two query as a one query . because presently i should executive

one by one.

SELECT T2.[SeriesName],T0.[JrnlMemo], T0.[DocDate], T0.[DocNum], T1.[WhsCode] FROM ODLN T0 INNER JOIN DLN1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN NNM1 T2 ON T0.Series = T2.Series WHERE T2.[SeriesName] =[%0] AND (( T1.[WhsCode] <> [%1]) AND (T1.[WhsCode] <> [%2]) AND (T1.[WhsCode] <>[%3])) AND T0.[DocDate] >=[%4] AND T0.[DocDate] <=[%5] ORDER BY T0.[DocDate]

SELECT T2.[SeriesName],T0.[JrnlMemo],T0.[DocDate], T0.[DocNum], T1.[WhsCode] FROM ORDN T0 INNER JOIN RDN1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN NNM1 T2 ON T0.Series = T2.Series WHERE T2.[SeriesName] =[%0] AND (( T1.[WhsCode] <> [%1]) AND (T1.[WhsCode] <> [%2]) AND (T1.[WhsCode] <>[%3])) AND T0.[DocDate] >=[%4] AND T0.[DocDate] <=[%5] ORDER BY T0.[DocDate]

Thank You

saman