Re: Joining values from 2 tables... more complicated

Ok, I had a look there but still... too confusing... cant anybody gimme a tip? ;) Dani "Becoming Digital" <subs@becomingdigital.com> escreveu na mensagem news:004201c318bd$b9dd27b0$f5fa5044@becomingadmin... > 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: [PHP-DB] 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 > > > --- 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