Hi!
To fetch information from several tables you usually use a join
operation. Here's a starting point in the MySQL manual.
http://www.mysql.com/doc/en/JOIN.html
/Lars ([EMAIL PROTECTED])
Cesar Aracena wrote:
Hi all,
I have several tables from which I have to fetch certain products
[EMAIL PROTECTED] (Cesar Aracena) wrote in news:005801c2a3c6$8ac4f190
$4200a8c0@NOTEBOOK:
And the subcategories are related to categories with the Relationships
table?
If that's the case:
SELECT * FROM Relationships WHERE CatId = '1'
And if you want the names.
SELECT * FROM Subcategories as
2 matches
Mail list logo
