How can I join 3 tables using JOIN keyword
Hi Experts,
Pls hlp me with my query
How can i join 3 tables using JOIN Keyword inside PL/SQL block in SELECT ... WHERE clause Query
3 Tables namely Reg,ROOTS,ME and the select statement takes both parameter variable and local variable
Thanks!!!!!
Software/Hardware used:
Software/Hardware used:
ASKED:
December 4, 2008 6:20 AM
UPDATED:
December 8, 2008 5:08 AM
Answer Wiki:
The basic syntax will be something like this.
<pre>SELECT *
FROM Reg
JOIN ROOTS ON Reg.Column2 = ROOTS.Column1
JOIN ME ON ROOTS.Column3 = ME.Column1
WHERE Reg.Column5 = 'test'</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
Yes i did similar code
pls find below the same and error i am still getting
My Select stm hav both IN parameter variable(p_rdc) and local variables (v_et,v_ftd,v_rtd)
and getting 2 error messages
1.SQL stm Ignorned and Error(19,75): PL/SQL: ORA-00923: FROM keyword not found where expected
SELECT rdc INTO p_rdc,et INTO v_et,
ftd INTO v_ftd,rtd INTO v_rtd
FROM reg JOIN roots ON reg.rtd = roots.rtd
JOIN me ON me.etd = roots.rtd
WHERE Deleted = 0
AND me.eud = p_eud;
You need to change your first 2 lines to:
SELECT rdc,et,ftd,rtd INTO p_rdc, v_et, v_ftd, v_rtd
Thanks it fixed my issue..