Hi Ck,
I have sql query only since i,m a functional consultant idon't have access to database.
Above mentioned are Sql queries.
Thanks for your response and contribution.
ANILESWAR
Last Activity: Sep 7 '10, 08:22 PM
Joined: Sep 7 '10
Location:
-
ANILESWAR replied to I want to join two queries to create a new query which will have all the informationin SQL ServerThanks CK.... for your response
I tried inner and outer joint but didn't get it may be missing some expression,don' t knowLeave a comment:
-
ANILESWAR started a topic I want to join two queries to create a new query which will have all the informationin SQL ServerI want to join two queries to create a new query which will have all the information
Below is the details of two queries and sql behind it and i'm doing this in Peoplesoft.Usin g Psquery.
Any help or procedure greatly appreciated.
IIGL_DEPT_AP_BV A_DETAIL:
SQL:
...Code:SELECT A.BUSINESS_UNIT, A.ACCOUNT, E.DESCR, A.LINE_DESCR, D.NAME1, F.INVOICE_ID, TO_CHAR(F.INVOICE_DT,'YYYY-MM-DD'), C.MONETARY_AMOUNT, A.DEPTID, B.DESCR, A.JRNL_LINE_SOURCE, A.CURRENCY_CD, TO_CHAR(A.JOURNAL_DATE,'YYYY-MM-DD'), A.JOURNAL_ID,E.SETID,E.ACCOUNT,TO_CHAR(E.EFFDT,'YYYY-MM-DD')
No activity results to display
Leave a comment: