2
Answers

i want to combine two different query result in two different column

Sonali Avhad

Sonali Avhad

3y
406
1
 I have 2 select queries. I want to show first select query result in first column ,second select query result in second column.
 
Column1  Column2
A1               A3
A2               A5
A4              A6
 
 
 column1 select query -
select SNO as column1 from tableA where sid=1 
column2 select query -
select SNO as column2  from tableA where sid=2
 
please  help me
 
Answers (2)