rewriting a MS SQL query to work with mySQL
I have a SQL query that works fine in MS SQL, but I want to be able to use this query in a mySQL database. The problem is mySQL doesn't support this type of query. MySQL doesn't support sub queries.
I've tried looking but can't seem to find out how I could perform this same thing in mysql a different way. I thougth I'd check to see if anyone might have a sugestion, or know of how to rewrite it to make it work.
Here is the SQL:
I don't see how I could do this with a table join because I have to get the minimum price for each product.
I didn't want to make my application have to execute a select query for each product it gets from that query because of the overhead involved. I would have to open a second DB connection to issue the select statements finding the minimum price for each product as the program iterates through the main query listed above. Plus this query is going to be one of the most heavily executed ones, so the least overhead the better.
Re: rewriting a MS SQL query to work with mySQL
Unsure which version of MySQL you're using, but MySQL does support sub-queries.
If you can, upgrade to MySQL 5 - the documentation regarding sub-queries within the SELECT part of the query is allowed. (http://dev.mysql.com/doc/refman/5.0/en/subqueries.html)
|All times are GMT +5.5. The time now is 10:50.|