ok, i'm stumped...
i have two queries that i want to intersect, but since intersect isn't supported and my host runs mysql 4.0.21 (so i can't use nested queries) i don't really know how to work around it...

i have two queries stored in variables, like:

PHP Code:
  $sql_know "select distinct student_id from knowledge_specification where area_id='$area_id'";
$sql_edu "select distinct student_id from education where kind='$kind' and name_id='$program_id'"
no i want to intersect them, like this:

PHP Code:
$sql $sql_edu " INTERSECT " $sql_know
but how? any help greatly appriciated...