Inner Joins using TOAD

Does anyone know what the SQL code would be in TOAD to do an Inner Join on an Oracle database?
bjmittsAsked:
Who is Participating?
 
jaramillCommented:
There is no TOAD specific SQL for inner-joins.  It works in whatever SQL environment you are in.

SELECT e.lname, d.name
   FROM employee e, department d
 WHERE e.dept_id = d.dept_id;

This is a normal join (which is also known as an INNER-JOIN).

If you wanted an OUTER-JOIN where one column in one table doesn't match the same column in the opposite table, thus it shows all NULLs, then you need to add a (+) sign to the optional table be it employee or department

SELECT e.lname, d.name
   FROM employee e, department d
 WHERE e.dept_id = d.dept_id (+);

Gio
0
 
Helena Markováprogrammer-analystCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept jaramill's comment as answer.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.