I have a database that holds basic "products", "users", and "sales" information for a shop.
I am having a few problems with a MySQL query that will retrieve the following information from the appropriate tables.
The Purchasers "Username".
The "Name" of the purchased item.
The "Price" of the purchased item.
The "time" the item was purchased.
If any items have been purchased multiple times by a purchaser, I need to only show the latest one. Can this be done?
The structure of the tables can be seen below.
Table "Products":
product_id - Used as a unique identifier.
name - The name of the product.
price - The price of the product.
Table "Users":
user_id - Used as a unique identifier.
username - The username of the purchaser.
Table "Sales":
sale_id - Used as a unique identifier.
product_id - The unique identifier of the purchased product.
user_id - The unique identifier of the purchaser.
time - The date and time the sale took place.
Can anyone help?
Any Help is Much Appreciated!
MySQL Query Containing Multiple Queries
Moderator: General Moderators
Re: MySQL Query Containing Multiple Queries
with what exactly you need help?...Can anyone help?
post your code
-
Peter Kelly
- Forum Contributor
- Posts: 143
- Joined: Fri Jan 14, 2011 5:33 pm
- Location: England
- Contact:
Re: MySQL Query Containing Multiple Queries
Just sort it by ID then limit it to just 1 row. So on the end of the SQL query you would add LIMIT 0,1
Re: MySQL Query Containing Multiple Queries
Good idea. ThanksPeter Kelly wrote:Just sort it by ID then limit it to just 1 row. So on the end of the SQL query you would add LIMIT 0,1