t1 A,2,3,4 t2 1,2a,3a,4a now union of tw0 table must be A,1,2,2a,3,3a,

Consider the table T1 it consits
A,2,3,4
consider another table t2 it contain
1,2a,3a,4a
now i need o get the upadted answer

Question Posted / sreekanthb87

Answer Posted / sreekanthb87

t1
A,2,3,4
t2
1,2a,3a,4a
now union of tw0 table must be
A,1,2,2a,3,3a,4,4a

now how you write the qurey ,the answer should be
A,1,2a,3a,4a

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What are orphan records?

889

What are the different Topologies in which Replication can be configured?

1120

Explain how does the report manager work in ssrs?

903

How many types of triggers in sql server?

972

What is transaction server auto commit?

990

What is the difference in accessing db between sql server vs sql azure?

174

According to you what goes into making the best database administrator? : sql server database administration

942

What is ms sql server reporting services?

995

How many types of local tables are there in sql server?

889

What is the main difference between ‘between’ and ‘in’ condition operators?

1106

what purpose does the model database serve? : Sql server database administration

924

How to retrieve error messages using mssql_get_last_message()?

994

How efficient you are in oracle and SQL server?

1091

When would you use the stored procedures or functions?

950

What are policy management terms?

935