Page 1 of 1

MySQL Query Containing Multiple Queries

Posted: Tue Jan 18, 2011 9:32 am
by portem1
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!

Re: MySQL Query Containing Multiple Queries

Posted: Tue Jan 18, 2011 9:36 am
by mikosiko
Can anyone help?
with what exactly you need help?...

post your code

Re: MySQL Query Containing Multiple Queries

Posted: Tue Jan 18, 2011 9:39 am
by Peter Kelly
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

Posted: Tue Jan 18, 2011 3:55 pm
by portem1
Peter 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
Good idea. Thanks :)