Sonali Avhad

Sonali Avhad

  • NA
  • 234
  • 42.2k

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

Apr 15 2021 11:30 AM
 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)