OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query [message #1094]

Sun, 31 March 2002 23:06

Manoj
Messages: 101
Registered: August 2000

Senior Member

Hi Experts,

Pls. Help me

DATA IN TABLE FAC_SOLD_ASST

SELECT SOLD_FAMG_CODE MG,SOLD_FASG_CODE SG
FROM FAC_SOLD_ASST;

MG SG
-- --
03 01
03 01
03 01
03 01

DATA IN TABLE FAC_FDPL

SELECT FDPL_FAMG_CODE MG,FDPL_FASG_CODE SG
FROM FAC_FDPL;

MG SG
------ ------
04 01

THE RESULT THAT IS WE WANT
MG SG
03 01
04 01

SELECT SOLD_FAMG_CODE,SOLD_FASG_CODE,
FDPL_FAMG_CODE,FDPL_FASG_CODE
FROM FAC_SOLD_ASST A , FAC_FDPL B
WHERE SOLD_FAMG_CODE=FDPL_FAMG_CODE(+) AND
SOLD_FASG_CODE=FDPL_FASG_CODE(+);

BUT OUTER JOIN NOT WORK IN THIS QUERY

PLEASE INFORM ME ABOUT THE REASON IMMIDATELY

Report message to a moderator

Re: Query [message #1096 is a reply to message #1094]

Mon, 01 April 2002 03:31

Srinivas
Messages: 138
Registered: June 2000

Senior Member

SELECT SOLD_FAMG_CODE MG,SOLD_FASG_CODE SG
FROM FAC_SOLD_ASST

UNION

SELECT FDPL_FAMG_CODE MG,FDPL_FASG_CODE SG
FROM FAC_FDPL

Report message to a moderator

Previous Topic:	Re: buffer over flows
Next Topic:	Need help on

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 15:36:09 CDT 2024