Home » RDBMS Server » Server Administration » Need help
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
Previous Topic: Maximum number of processes (100) exceeded
Next Topic: Re: Thankyou very much Salman Khan
Goto Forum:
  


Current Time: Thu May 02 14:05:13 CDT 2024