To get the given output using sql query

Vote count:

0

I had been asked an sql query in an interview. I couldn't solve it and still I am unable to. I used joins as was suggested by the interviewer but couldn't get the desired output. The interview got over but I still am curious as to how this problem can be solved. Maybe u guys can help me out

Table A
x
x
Table B
x
Output: 
x x
x NULL

So there are two tables table A with 1 column and two rows of same elements and table b of only one element which is same as in table A. Now I have to get the output like shown above. How to do it?

asked 35 secs ago

Sidarth

51

To get the given output using sql query