| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Critters | Date: | May 23 2006 10:52am |
| Subject: | I think I need a join | ||
| View as plain text | |||
I think the following could be done with some sort of JOIN, but I am now sure how: [country]: id, country, number 1, Germany, 27 2, Japan, 30 3, United States, 18 [days] id, day, countryA, countryB 10, monday, 1, 3 11, tuesday, 2, 3 12, wednesday, 1, 2 [result I want] 10, monday, Germany, 27, United States, 18 11, tuesday, Japan, 30, United States, 18 12, wednesday, Germany, 27, Japan, 30 Hope that makes sence :) I can get it to join on either countryA or countryB but not both :| -- David
