Results 1 to 2 of 2
Jan 6, 2011, 20:07 #1
- Join Date
- Apr 2003
- daejeon, South Korea
- 1 Post(s)
- 0 Thread(s)
producing as many as row count in the table "group1" with UNION resultsCode:
data in the table "words" word1 word2 gold jewelry jewelry diamond
The code below yields the result below.
code SELECT word2 as word FROM words WHERE word1='jewelry' UNION ALL SELECT word1 as word FROM words WHERE word2='jewelry' result diamond gold
Here goes what I want.
I have another table named myGroup1 like the below.
data in the table "myGroup1" group1 group1-1 group1-2
target result diamond group1-1 diamond group1-2 gold group1-1 gold group1-2