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

last function used in MS Access to convert sql what function will use in sql

2114

System requirements for sql server 2005 express edition?

1070

Can you explain full-text query in sql server?

1059

what is bit datatype? : Sql server database administration

963

Difference between report and query parameter.

1144

What is a mixed extent?

1080

How do you create an execution plan?

1008

What is the difference between truncate and delete commands?

1110

What is database dimension? : sql server analysis services, ssas

1142

What is tabulation?

1014

What are dml (data manipulation language) statements in ms sql server?

1027

What is measure group, measure? : sql server analysis services, ssas

1073

What is difference between order by and group by?

1056

What to check if a User database is locked?

1117

How do I create a trace in sql server?

1092