JOINING... 2004-03-22 - By David Scott
Back
Hiya peeps.
I have a table which looks something like this:
TABLE1
id, something, page1, page2, page3
1, "wibble ", 1, 3, 5
TABLE2
id, name
1, "hello "
2, "world "
3, "why can 't "
4, "i get "
5, "this to work "
I want to SELECT everything from TABLE1 replacing the numbers in page1, 2, 3
with the words is TABLE2.
RESULT
id, something, page1, page2, page3
1, "wibble ", "hello ", "why can 't ", "this to work "
I usually just do "SELECT * FROM table1 WHERE table1.page1 = table2.id " but
this doesnt work when there are multiple pages (page1, 2, 3 in table1)
Help :S
I 've tried using joins but I can 't seem to get the syntax right...
and yes. I have read the manual, just not sire if the bit I read (joins) is
the bit I need to read
--
Dave
--
MySQL General Mailing List
For list archives:
http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=mysql
@(protected)
|
|
