Require Help On A Query ---urgently

[mkkalia]

I am new to php and i am working on a project where i need to implement the following logic . Please help with the query ->

I have 3 tables ->
hotel ( HotelId,HotelName ) ([1,a],[2,b] , [3,c])
tags ( tagid,tagname,taggroupid) ([1,1star,1],[2,2star,1],[3,bar,2])
hoteltags ( HotelId,tagid)([1,1],[2,1],[3,1],[1,2],[3,2])

I have to apply an sql query that would give me the following results :

case 1 : Selection of 1star , 2star gives all hotelids containing both 1star and 2 star => (Intersect ) OUTPUT : 1

case 2 : Selection of 1star,bar gives all hotelids in 1star and bar -> 1,2,3


Can you pls help with the first case as i am not able to create an intersect query which will give me the above results .

For case 2 i was able to generate the foll query :
HotelId IN (SELECT hotelId FROM `hoteltags` WHERE tagId IN ( SELECT tagId FROM tags WHERE tagName IN (" . '1star' ,'2star' . ")))

[amitpatel66]

I am new to php and i am working on a project where i need to implement the following logic . Please help with the query ->

I have 3 tables ->
hotel ( HotelId,HotelName ) ([1,a],[2,b] , [3,c])
tags ( tagid,tagname,taggroupid) ([1,1star,1],[2,2star,1],[3,bar,2])
hoteltags ( HotelId,tagid)([1,1],[2,1],[3,1],[1,2],[3,2])

I have to apply an sql query that would give me the following results :

case 1 : Selection of 1star , 2star gives all hotelids containing both 1star and 2 star => (Intersect ) OUTPUT : 1

case 2 : Selection of 1star,bar gives all hotelids in 1star and bar -> 1,2,3


Can you pls help with the first case as i am not able to create an intersect query which will give me the above results .

For case 2 i was able to generate the foll query :
HotelId IN (SELECT hotelId FROM `hoteltags` WHERE tagId IN ( SELECT tagId FROM tags WHERE tagName IN (" . '1star' ,'2star' . ")))

I would just modify your query slightly to get case 1:

 
SELECT hotelname from hotel where hotelid IN(
HotelId IN (SELECT hotelId FROM `hoteltags` WHERE tagId IN ( SELECT tagId FROM tags WHERE tagName IN (" . '1star' ,'2star' . "))))
 
 

Please make sure you use [code] tags when ever you post any source code