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/[EMAIL PROTECTED]