var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: joining 2 tables - 10g
I have 2 tables, one of them containing 200 columns and the other containing 30 cols.
I wanted to write a query that uses about 70 cols from the first table and 10 from the second.
Is there any way to do this other than using aliases?
select datetime, col1+col2+........+col80 AA
from table a, table b
E.g., I don't want to do: as it's too cumbersome.
select a.col1, a.col2.........a.col70, b.col1, b.col2...........b.col10
from table1 a, table2 b
Last edited by shajju; 10-28-13 at
You have to list the columns that you want.
Thanks. The columns are all of 'number' type with the exception of datetime (date) and one py-key col being varchar(2) type.
OK, you still have to list the columns that you want to display, and you'll need to qualify them with either the table name or an appropriate alias if there are any column names common across the two tables (and I'd recommend qualifying them even if there isn't)