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


Please Help Members By Posting Answers For Below Questions

How to run pl/sql statements in sql*plus?

758


What is the starting oracle error number?

757


What is exception? What are the types of exceptions?

789


How can use stored procedures in sql?

773


how to dump a table to a file with 'mysqldump'? : Sql dba

739






How do I run sql?

826


Does view contain data?

788


Is a foreign key always unique?

677


What is t sql used for?

733


Can we write ddl statements in functions?

796


How many types of relationship are there?

735


How to handle bulk data?

1050


What are sql functions? Describe in brief different types of sql functions?

720


Is it possible for a table to have more than one foreign key?

774


What is field delimiter?

793