If you want to know how many sales were made to a give client (e.g. where IDclie =
99), this should see you right:
SELECT count(*)
FROM Sale, Basket
WHERE Sale.idbask = Basket.IDbask
AND Basket.IDClie = 99
Paul Vincent
DBA
University of Central England
-----Original Message-----
From: RuiSMonteiro [mailto:[EMAIL PROTECTED]
Sent: 27 July 2004 09:44
To: [EMAIL PROTECTED]
Subject: MySQL table design
Hello,
I'll try to explain correctly my idea.
I need to develop a on-line sale's website. For that, I have some dough's on how to
create the table "basket".
Client
- IDclie (PK)
- ...
Produts
- IDprod (PK)
- ...
Basket
- IDbask (PK)
- IDprod (FK)
- IDClie (FK)
- qt
- date
Sale
- IDsale (PK)
- idbask (FK) -> there should only be one ID per basket...in this case.
- shipping_debit
- ...
I dont know how to make a propper relation when it comes to (Client - Basket), because
I wanted to know how many sales a client made.
I was thinking on making an extra table by removing IDclie from Basket and making this:
Clie/Basket
- IDclie (PK)
- IDbask (PK)
But I can't really add any values due to foreign key constraints.
Any help on how to resolve my problem? How should I solve this?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
