var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: displaying results of 2 queries side by side - 10g
I have 2 queries which have the same PK columns but return a different number of columns.
Query 1 returns 5 cols (1 row)
Query 2 returns 2 coumns (1 row)
Both queries have the datetime column result in common.
Can I show the 6 cols from both queries side by side ?
select a.*, b.* from (query1) a join (query2) b on a.datetime=b.datetime
but the datetime column (from the second query) is being repeated.
How can I get rid of this column?
Last edited by shajju; 02-03-14 at 04:14.
Problem solved. Apologies for needless question.
How did you solved your issue?