table relationship
| From: | Manuel | Date: | Wed, 06 Sep 2000 17:13:37 +0000 |
| Subject: | table relationship | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-2700@lists.php.net to get a copy of this message | ||
I have two tables, one customer and one sales.
Table: Customer
custid - primary key
custname
custadd
Table: Sales
custid - primary key
date
purchases
Question:
How do I extract custname from customer table when I do a search in the sales table?
I would like to have these fields:
1) custid
2) custname
3) date
4) purchases
Do I need to set the relationship for the two tables?
Any help would be appreciated.
Thank you.