Joining values from 2 tables... more complicated
| From: | Dani Matielo | Date: | Mon, 12 May 2003 19:09:44 +0000 |
| Subject: | Joining values from 2 tables... more complicated | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27679@lists.php.net to get a copy of this message | ||
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