OraFAQ Forum: MySQL » Oracle In-Line Query alternative for MySQL view

Home » Open Source » MySQL » Oracle In-Line Query alternative for MySQL view (N/A)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle In-Line Query alternative for MySQL view [message #339081]

Wed, 06 August 2008 13:05

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

Report message to a moderator

Re: Oracle In-Line Query alternative for MySQL view [message #339083 is a reply to message #339081]

Wed, 06 August 2008 13:10

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.

Report message to a moderator

Previous Topic:	Oracle 9i Connectivity Problem with MySQL
Next Topic:	Data Migration from MySql to Oracle 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 00:57:08 CST 2025