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 do I restart sql?

524


What is the difference between execution of triggers and stored procedures?

548


how many sql dml commands are supported by 'mysql'? : Sql dba

567


What is coalesce in sql?

559


How do I start sql profiler?

555






when MSQL8.0 is in market

1598


what is single byte over head in oracle..?

1870


Why select is used in sql?

516


how to extract a unit value from a date and time? : Sql dba

556


What is cascade in sql?

559


Which is better stored procedure or query?

546


What is the difference between alter trigger and drop trigger statements?

599


What is cross join sql?

498


Is sql a dbms?

530


Can we use commit inside a trigger?

521