I have 2 table. Zones(Z1......Z20) and Radius(R0..R4) where R0 is equivalent to Z1 R1 " Z5 R2 " Z9 R3 " Z13 R4 " Z17
How can I make the query to join them in such ways? eg: select A,B,C,D from Zone inner join radius on R1 = Z5 on R2 = Z9 on R3 = Z13 on R4 = Z17 or do I have to use a subquery?? -- Ow Mun Heng <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
