crartesion product of two tables

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

Question Posted / mahesh

Answer Posted / mahesh

Is This Answer Correct ?

6 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Can primary key be changed?

913

What is sql*loader and what is it used for?

1158

what are the features and advantages of object-oriented programming? : Sql dba

1017

When you have to use a default "rollback to" savepoint of plvlog?

1204

what is a trigger? : Sql dba

1036

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

977

Does sql between include endpoints?

1018

Why indexing is needed?

993

what are the different tables present in mysql? : Sql dba

988

What is field delimiter?

1051

How many triggers can be applied on a table?

937

How do I copy a table in sql?

995

Can we insert in sql function?

1094

what is a foreign key ? : Sql dba

1087

Is foreign key mandatory?

1011