Re: Joining values from 2 tables... more complicated
| From: | Becoming Digital | Date: | Mon, 12 May 2003 19:36:04 +0000 |
| Subject: | Re: Joining values from 2 tables... more complicated | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27681@lists.php.net to get a copy of this message | ||
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