Need help [message #371610] |
Tue, 14 November 2000 11:49 |
Prabhakar Allathur
Messages: 10 Registered: October 2000
|
Junior Member |
|
|
Hi,
I have a question i.e., out of many tables in the database I need to use three tables
user table where I have user_id,
Purchase_log table where I have order_number, user_id, order_status, Order_timestamp
and
Purchase_log_items where I have Product_id, product_name,order_number
The client asked me to find out a solution that they will require to know
(1)If a registered user has logged on
(2)If a registered user has made a purchase
(3)If a registered user has purchased a given category or subcategory of
product
I'm not sure weather the question is related to the database or not, if it is there a solution please
Thanks in advance
|
|
|