Cross join returning row from only one table

Question

I'm trying to get two different columns by cross joining on same table but getting only on e column. Following is the sample query :

select 1 from dual cross join (select 2 from dual) t1;

Expected Result : 1 2

but getting only 1.

You're selecting 1. Perhaps, you want to select all columns (select *). — default locale
– default locale, Commented May 2, 2018 at 12:29
I was selecting columns in an incorrect manner. Selecting all required columns in 1st select statement solved the problem — ProgrammingEnthusiast
– ProgrammingEnthusiast, Commented May 2, 2018 at 12:38

Lajos Arpad · Accepted Answer · 2018-05-02 12:29:26Z

2

You have the select clause of

select 1

where you select a single column. If you want an output of 1 2 then use

select 1, 2

as your select clause.

answered May 2, 2018 at 12:29

Lajos Arpad

80.4k42 gold badges122 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ProgrammingEnthusiast Over a year ago

Thanks, yes all required columns should be a part of first select statement

Lajos Arpad Over a year ago

@ProgrammingEnthusiast since your problem has been solved, please, mark the best answer as the correct answer, so later visitors will see the solution at first glance.

Yogesh Sharma · Accepted Answer · 2018-05-02 12:29:18Z

1

You are not retrieving data from t1

select 1 as id, t1.*
from dual cross join (select 2 id1 from dual) t1;

answered May 2, 2018 at 12:29

Yogesh Sharma

50.2k5 gold badges31 silver badges53 bronze badges

Collectives™ on Stack Overflow

Cross join returning row from only one table

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related