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

Posted by Rajesh123 under Oracle on 8/11/2015 | Points: 10 | Views : 359 | Status : [Member] | Replies : 4
Join two tables retrieve second table column value..please reply answer this question

rajesh.plsql123@gmail.com


Responses

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

Up
0
Down

Resolved
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] Bronze | Points: 25

Up
0
Down
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 9731764134
Thanks

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

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

Up
0
Down
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

Up
0
Down
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

Login to post response