Home » Open Source » MySQL » Oracle In-Line Query alternative for MySQL view (N/A)
Oracle In-Line Query alternative for MySQL view [message #339081] Wed, 06 August 2008 13:05 Go to next message
aliceg
Messages: 29
Registered: July 2007
Location: Los Angeles
Junior Member

Hi Experts:
I need help with a work around for below in-line query which I need transposed in a view in MySQL (MySQL does not accept view creation with subqueries of any kind). I am working on a MySQL project which needs completed ASAP
Here is the query which gives me the desired result
Thanks so much
SELECT Providers.name, Providers.context, Rates.phone_no, Rates.cost,
             Providers.prov_id, Rates.rate_id
FROM	 Providers,
          	 Rates,
(SELECT min(cost) least_cost, phone_no
               from Rates
GROUP BY phone_no) least_rate
WHERE Providers.prov_id = Rates.prov_id AND
	 Rates.phone_no = least_rate.phone_no AND
             least_rate.least_cost = Rates.cost  

Re: Oracle In-Line Query alternative for MySQL view [message #339083 is a reply to message #339081] Wed, 06 August 2008 13:10 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> I am working on a MySQL project which needs completed ASAP
I suggest you post this in some MYSQL forum.

Please explain why it is urgent for US to solve this problem for you.
Previous Topic: Oracle 9i Connectivity Problem with MySQL
Next Topic: Data Migration from MySql to Oracle 11g
Goto Forum:
  


Current Time: Thu Mar 28 11:59:32 CDT 2024