How do you get all records from 2 tables. Which join do you use?
- 8 Answers
- 17765 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / selvaraj v , anna univ coe
Use Full Outer Join in Oracle 10g :
SELECT p.part_id,s.supplier_name FROM part p
FULL OUTER JOIN
supplier s ON p.supplier_idv = s.supplier_id;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How much does a sql dba make? : SQL DBA
How to run sql statements through the web interface?
Can you sum a count in sql?
What is nosql example?
What is a sql trace file?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is a recursive join sql?
What are the different sql commands?
what is csv? : Sql dba
What is a heap in sql?
Explain the insert into statements in sql?
Explain the difference between 'between' & 'and' operators in sql
what is a constraint? Tell me about its various levels. : Sql dba
Which join condition can be specified using on clause?
What is the difference between left join and right join?
