Results 1 to 12 of 12
Thread: instead of intersect?
Feb 10, 2005, 11:23 #1
- Join Date
- Jun 2001
- Stockholm, Sweden
- 0 Post(s)
- 0 Thread(s)
instead of intersect?
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:
$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'";
$sql = $sql_edu . " INTERSECT " . $sql_know;