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
|
|
|
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
|
|
|