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

What is the most restrictive isolation level? : Transact sql

1074

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

962

Can we write ddl statements in functions?

1104

Can we update views in sql?

932

what does the t-sql command ident_incr does? : Transact sql

1063

Could you please provide oca (oracle 10g) dumps for my certification ?

5143

Is vs as in pl sql?

979

how to return query output in html format? : Sql dba

1067

what is a constraint? Tell me about its various levels. : Sql dba

980

What is procedure explain with program?

1005

What are sql procedures?

1015

Which version of sql do I have?

1046

What is dialect in sql?

939

Is there a way to automate sql execution from the command-line, batch job or shell script?

962

How can I get the number of records affected by a stored procedure?

1050