I'm trying to create a result set of table names and column names. In table A I have the list of table names and in Table B I have the list of column names. Each table should have the full list of columns. So:

• Table A

• Table B

The result I want is:

So I have select

select
        table_name
        column_name
from
        A
full outer join
        B
on
        A.TABLE_NAME = B.COLUMN_NAME

Which gives me:

Close, but no cigar! How can I get my answer please?

CodePudding user response：

Use this:

select A.table_name, B.column_name from A, B;