use full outer join you can get the records

How do you get all records from 2 tables. Which join do you use?

Question Posted / vinay

Answer Posted / vinay

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is integrity in sql?

979

What is plpgsql language?

977

How do we accept inputs from user during runtime?

990

How do I tune a sql query?

934

What is data manipulation language?

1134

How do I order columns in sql?

912

what is timestamp in mysql? : Sql dba

1001

what is user defined functions? : Sql dba

975

what are the different index configurations a table can have? : Sql dba

937

What is error ora-01000: maximum open cursors exceeded

1061

How do we use distinct statement? What is its use?

976

What is meant by truncate in sql?

1003

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1156

What is pl sql block in dbms?

949

describe transaction-safe table types in mysql : sql dba

944