Really more of an SQL question, so here's the MySQL join reference. http://www.mysql.com/doc/en/JOIN.html Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Dani Matielo" <dmatielo@uol.com.br> To: <php-db@lists.php.net> Sent: Monday, 12 May, 2003 15:09 Subject: Joining values from 2 tables... more complicated Hey, there. Here is another problem about joining values from 2 tables: I have this table "space" with space1 space2 space3 just one line. and another table "products" id name description the values of space1, 2 and 3 are id's from the table products... so i needed a result like space1(id), space1(name), space1(description) and so on for the 3 spaces... How do I do that? :) thanks a lot (again!!) Dani --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.476 / Virus Database: 273 - Release Date: 24/4/2003 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
