producing as many as row count in the table "group1" with UNION results
I have the table like the above.
data in the table "words"
The code below yields the result below.
So far, so good.
SELECT word2 as word
SELECT word1 as word
Here goes what I want.
I have another table named myGroup1 like the below.
I like to yield my target result below joining the table "words" and "group1."
data in the table "myGroup1"