Something basic :
I have two tables tbl1 and tbl2 in a mysql database.

The first table has three records X, Y, Z
and the the second table has two records A and B

They have no common fields ( foreign keys )

With an SQL statement I'd like to generate a list of six records looking like this :
  • X A
  • X B
  • Y A
  • Y B
  • Z A
  • Z B

(Sequence is not important)
There is some basic function to do this which I can't recall at the moment.
I have a suspicion that it is only possible in Oracle with the sub-select
statements ( = select f1 from tblx where f2 = (select f3 from tbly) ; )
Can you help me on this?