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 functions can a view be used to performed?

1064

Can an automatic recovery be initiated by a user?

1020

What is a linked server in sql server?

1082

What is the dbcc command and why is it used?

1061

What is difference between count (*) and count column?

910

What is a result set object returned by mssql_query()?

1168

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1084

Tell me can we use custom code in ssrs?

1012

Explain cursor as data base object?

1048

What are the different acid properties?

1074

What are the new data types are introduced in sql 2000?

912

What is policy based management (pbm)? : sql server database administration

995

Which language rdl files made of?

133

Create and insert into temp table in sql server?

1039

What is the purpose of update statistics and scope_identity() function?

1104