How do you get all records from 2 tables. Which join do you use?
Answer Posted / pervez
using full outer join or Cartesian join we can get all records
from two tables
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What is sql profiler in oracle?
How do you copy a table in sql?
What is a sql schema used for?
How to connect a sql*plus session to an oracle server?
What is a behavioral trigger?
How do I run a sql query in pgadmin 4?
Is it possible to create the following trigger: before or after update trigger for each row?
What is sql comments?
What are pl sql data types?
What pl/sql package consists of?
What is range partitioning?
how many sql dml commands are supported by 'mysql'? : Sql dba
What is a dirty read sql?
how to create a test table in your mysql server? : Sql dba
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?