Simple query pareto question

I have two tables, 1 column each.  one has the values:

A
B
C

the other has the values:

1
2
3

they are unrelated.  i want the output to be 1 columns that looks like:

A 1
A 2
A 3
B 1
B 2
B 3
C 1
C 2
C 3

how can i do this? thanks
bdietzAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
select colA, colB
from tableA cross join TableB
0
 
AristoCommented:
select * from
table1, table2
0
 
awking00Commented:
select letters.col1||nums.col1
from letters, nums
order by letters.col1;
0
 
awking00Commented:
I think your acceptance was a little quick, since it returns two columns and not one as in your question.
0
 
awking00Commented:
p.s. It also doesn't sort them in your desired order.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.