Help combining two Oracle SQL queries

Question

I am using 2 SQL queries. the 2nd produces additional columns not contained in the first query.

I would like to see if they can be combined so the original query produce same original data plus the additional columns that the 2nd query currently produces.

Dan

Answer 1

Are both queries done on the same table? Or are they queries from 2 different tables?

if it is the first case, it depends on the actual statement, if the sets of columns have nothing in common you can use “or”. If there is no “where” you could just name all the columns after select.

if they are 2 tables and have a shared key column, you can join the tables and print the columns in the steps mentioned above.