Solved

Inner Joins using TOAD

Posted on 2003-11-13
3
2,857 Views
Last Modified: 2013-12-12
Does anyone know what the SQL code would be in TOAD to do an Inner Join on an Oracle database?
0
Comment
Question by:bjmitts
3 Comments
 
LVL 3

Accepted Solution

by:
jaramill earned 50 total points
ID: 9854982
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
 
LVL 22

Expert Comment

by:Helena Marková
ID: 10200411
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now