Hi, I'm Carlo and I've this question: I've 2 tables, with this structures:
Table1: product Table2: measures 1) ID 1) ID 2) weight 2) symbol 3) ID_weight_measure 4) height 5) ID_height_measure OK. Is there a way to obtain with a single select statement both (or any...this is only an example) the joins ID_weight_measure with the related symbol, and the ID_height_measure with its symbol? I don't know if it's a many-to-many relationship, and even if it is, I don't know how to implement it. I hope in your help. Ciao carlo ______________________________________________________________________ Abbonati a Yahoo! ADSL con Atlanet! Naviga su Internet ad alta velocitą, e senza limiti di tempo! Per saperne di pił vai alla pagina http://adsl.yahoo.it --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php