Select column_name from tableA UNION Select column

How to fetch common records from two tables?

Question Posted / mrityunjay dubey

Answer Posted / mrityunjay dubey

Select column_name from tableA UNION Select column_name from tableB

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to change the order of columns in Oracle SQL Plus ?

1038

What are the uses of merge?

1150

What can sql server reporting services do?

1095

What are sql constraints?

1159

Is not equal in sql?

996

What is set transaction?

1018

define data blocks ? : Sql dba

966

Explain the the delete statements in sql?

1040

Are subqueries better than joins?

956

What is PL/SQL Records?

1166

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1080

How is data stored on a disk?

1004

what is sql? : Sql dba

1002

Can you sum a count in sql?

985

Which command is used to call a stored procedure?

986