MySQL Forums
Forum List  »  MySQL Query Browser

Lookup query problems
Posted by: harold content
Date: January 24, 2012 05:41AM

query

I'm looking for a query that does the following in Mysql

What he does is pick up the final price of an item. I use this code only if he does anything or not but he grabs the latest price!

Does anyone know how the final price can get it out.

Prizes will be saved per year on a weekly level.

Code:

SELECT tblart.aid
, tblart.A_nr
, tblart.A_naam
, tblprijs.ap_prijs
, tblprijs.ap_week
, tblprijs.ap_jaar
FROM
vm06inkdb1.tblart
INNER JOIN vm06inkdb1.tblprijs
ON tblart.aid = tblprijs.aid
WHERE
tblart.A_nr = 774971
GROUP BY
tblprijs.aid

Options: ReplyQuote


Subject
Written By
Posted
Lookup query problems
January 24, 2012 05:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.