Join two tables retrieve second table column value '@' [Resolved]

Posted by Rajesh123 under Oracle on 8/11/2015 | Points: 10 | Views : 1572 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Join two tables retrieve second table column value..please reply answer this question

rajesh.plsql123@gmail.com

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Kmandapalli on: 8/12/2015 [Member] Silver | Points: 50

0	Hi Rajesh, Below is the query to get the column value of second table, SELECT e2.FirstName FROM employees e1 JOIN employees e2 ON (e1.employee_id = e2.manager_id) Mark as answer if satisfied.... Thanks, Kavya M. Kavya Shree Mandapalli Rajesh123, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Amatya on: 8/12/2015 [Member] Silver | Points: 25

0	SELECT column-names FROM table-name1 JOIN table-name2 ON column-name1 = column-name2 WHERE condition Plz Mark as answer Thanks, Amatya Feel free to share informations. mail Id ' adityagupta200@gmail.com Thanks Rajesh123, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ranjitha21 on: 8/12/2015 [Member] Starter | Points: 25

0	SELECT column-names FROM table-name1 JOIN table-name2 ON column-name1 = column-name2 WHERE condition http://www.onlinemarketingcourse.in/seo-training-in-chennai/ Rajesh123, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Shreedar on: 8/15/2015 [Member] Starter | Points: 25

0	SELECT column_list FROM fisrt_table RIGHT JOIN second_table ON join condition. Ex: select ename, esal, depname from emp inner join department on emp.dpid=department.id Right join gives you all columns from second table and matching columns from first table. Regards, Sridhar Thota. Regards Sridhar Thota. www.dotnet-sridhar.blogspot.com Rajesh123, if this helps please login to Mark As Answer. \| Alert Moderator

SELECT column_list
FROM fisrt_table
RIGHT JOIN second_table
ON join condition.

Ex:
select ename, esal, depname
from emp
inner join department
on emp.dpid=department.id

Right join gives you all columns from second table and matching columns from first table.

Regards,
Sridhar Thota.

Regards

Sridhar Thota.
www.dotnet-sridhar.blogspot.com

Rajesh123, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts