|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
 |
| | LinkBack | Thread Tools | Display Modes |
06-10-2007, 12:22 AM
| #1 | ||
 |
Please help. I have two tables with a one to many relationship. Each property can have many prices. I need to be able to get the most recent price for each property and have tried 10 different ways but cannot get it to work. Any ideas would be greatfully accepted. Properties with these fields. `Properties`.`PropertyID`, `Properties`.`PropertyAddress`, `Properties`.`PropertyCity`, `Properties`.`PropertyState`, `Properties`.`PropertyZipCode` PropertyPrice `PropertyPrice`.`PropertyPriceID`, `PropertyPrice`.`PropertyPriceDate`, `PropertyPrice`.`PropertyPrice`, `PropertyPrice`.`PropertyID` | ||
     |
|
06-10-2007, 12:22 AM
| #2 | ||
| |
SELECT Properties.PropertyID, Max(PropertyPrice.PropertyPrice) AS MaxOfPropertyPrice, Properties.PropertyAddress, Properties.PropertyCity, Properties.PropertyState, Properties.PropertyZipCode FROM Properties INNER JOIN PropertyPrice ON Properties.PropertyID = PropertyPrice.PropertyID GROUP BY Properties.PropertyID, Properties.PropertyAddress, Properties.PropertyCity, Properties.PropertyState, Properties.PropertyZipCode ORDER BY Properties.PropertyID; Resolved. wibble wrote: > Please help. > I have two tables with a one to many relationship. Each property can > have many prices. > > I need to be able to get the most recent price for each property and > have tried 10 different ways but cannot get it to work. > > Any ideas would be greatfully accepted. > > > Properties with these fields. > `Properties`.`PropertyID`, > `Properties`.`PropertyAddress`, > `Properties`.`PropertyCity`, > `Properties`.`PropertyState`, > `Properties`.`PropertyZipCode` > > PropertyPrice > `PropertyPrice`.`PropertyPriceID`, > `PropertyPrice`.`PropertyPriceDate`, > `PropertyPrice`.`PropertyPrice`, > `PropertyPrice`.`PropertyID` | ||
| |
| Featured Websites | ||||
|
|
| Tags: 4112, issue, mysql, query |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how can I do a VERY large mysql query... | Shawn Wilson | Database | 2 | 05-31-2007 8:48 PM |
| MySQL Query Cache Not Working: MySQL 5 / Windows XP | Good Man | Database | 0 | 05-31-2007 8:46 PM |
| mysql 3 and query | Jean-Luc M. | Database | 3 | 05-31-2007 8:44 PM |
| Mysql - Query Cache Hitrate = 0% ? | Nicolai | Database | 2 | 05-31-2007 8:39 PM |
| Query MySQL send results in CSV (XLS) | Joe Gazda | Database | 1 | 05-31-2007 8:39 PM |
| Featured Websites | ||||
|
mysql 4.1.12 query issue 
PacMan
Linear Mode
