gt;
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 10:09 AM
Subject: [PHP-DB] joining 2 tables - help please..
> I have 2 tables as follows:
>
> product table
> | product_id | name | category_id
> | 1| coffee| 2
> | 3
I have 2 tables as follows:
product table
| product_id | name | category_id
| 1| coffee| 2
| 3| orange|1
| 5| mango|1
| 2| tea |2
and
category table
|category_id | category_name |
|2| drinks
I am having trouble getting the correct join...here is my scenario.
I have 2 tables, A and B.
A looks something like this...
[id][name]
1Name1
2Name2
3Name3
B looks like this...
[userid][tableAid]
11
13
21
2