MySQL Forums
Forum List  »  Spanish

Consulta en MySQL
Posted by: alberto rengifo
Date: June 02, 2011 10:58PM

Hola todos, soy nuevo pro aquĆ­ y necesito de vuestra ayuda

Estoy trabajando con KumbiaPHP y phpMyAdmin...estoy realizando la siguiente consulta directamenete desde el phpMyAdmin pero tengop un error con la palabra intersect ya que leyendo supe que MySQL no la soporta....

Mi pregunta es, como puedo cambiar esta consulta?

SELECT DISTINCT R.nombre
FROM restaurante R, presta P, servicios S
WHERE P.restaurante_id IN
(select R.id
from presta P
where P.servico_id=4

intersect

select R.id
from presta P
where P.servico_id=6 )

AND P.servicio_id= S.id
AND R.id = P.restaurante_id;

Options: ReplyQuote


Subject
Views
Written By
Posted
Consulta en MySQL
1718
June 02, 2011 10:58PM
757
June 03, 2011 03:07AM


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.