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