I have a requirement where I have two tables of data that are not related, but I need to list all FORM records for each STUDENT record for an APEX report. I did a search on joins and the closest thing I found was a FULL OUTER JOIN, but that relies on a join column. I am using Oracle 19c.

TBL_FORMS

FORM_ID | FORM_NAME      | ITEM_NAME
==============================================
1       | Favorite Color | Blue
1       | Favorite Color | Green

TBL_STUDENTS

STUDENT_ID | STUDENT_NAME | STUDENT_GRADE
=========================================
1          | John         | 1
2          | Sally        | 4

DESIRED RESULT

STUDENT_ID | STUDENT_NAME | STUDENT_GRADE | FORM_ID | FORM_NAME      | ITEM_NAME
=======================================================================================
1          | John         | 1             | 1       | Favorite Color | Blue
1          | John         | 1             | 1       | Favorite Color | Green
2          | Sally        | 4             | 1       | Favorite Color | Blue
2          | Sally        | 4             | 1       | Favorite Color | Green