hi how do u create a query to select two diff values of the same column from another table using a left join? i know i'd retrieve them with aliases but where do i set which alias is for which value?
here's a simplified version of the tables table1: colours id colour table2: choices id old new old and new are both ids in the 'colours' table. what i wanna do is something like: select id, colours.colour as old1, colours.colour as new1 from choices left join colours on colours.id = old... now here, can an and clause be used so it reads on as... and colours.id = new or do i put another left join? either ways, how do i specify which join / equality is which alias or whateva? i don't wanna use two queries...as far as possible. ty abs ps: i wouldn't be going through all this just for colours ;-) also (unrelated to mysql) ;-) i didn't know that pink's song "feel good time" is from charlie's angels 2. just saw the video on mtv and realised. my question: the rythym guitar, bass and to some extent, the lead guitar are playing this tune throughout the song, any idea which song it's from? i don't think it's original to that song, anyone know where...? ________________________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
