Loading

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

Sonali Avhad

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sonali Avhad5y ago
It giving following error
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Sachin Singh5y ago
yes, then use three select queries one over two.
select
(select SNO from tableA where sid=1 ) as col1,
(select SNO  from tableA where sid=2) as col 2