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 is bit data type?

1012

List out the difference between union and union all in sql server?

969

How to make remote connection in database?

990

What are the purposes of floor and sign functions?

956

What is a mixed extent?

995

How is table type constraint applied to a table?

961

can any body tell me how to know the password of current user in sql server

2054

what are acid properties? : Sql server database administration

975

Explain transaction server consistency?

947

Explain iaas, paas and saas?

how you can list all the tables in a database?

1012

What are a scheduled jobs or what is a scheduled tasks?

885

What is sql server programming?

1020

How to create an index on a view?

1045

What are cursors in ms sql server?

1154