Intersects?

[bluedollar]

I am using mysql with PHP and I want to do the following:

select timetable_id
from timetable
where location_id = '.location_id.'
intersect
select timetable_id
from timetable
where start_date between '.$startdate.' and '.$enddate.'
or end_date between '.$startdate.' and '.$enddate.'";

Anything between '..' are elements on my form.

The query above is coming up with an error, so I guess that mysql does not support intersects yet. Is there a way of acheiving the above without using an intersect?

Any help would be greatly appreciated.

Thanks

Dan

 

[sleipnir214]

Have you tried:

select timetable_id
from timetable
where location_id = <location_id> and
(start_date between <startdate> and <enddate>
or end_date between <startdate> and <enddate>)

?

The parentheses may not even be necessary, but I don'd know for sure what operator precedence is in MySQL.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!