havencruise

Thank you.. That sounds exactly like what I need to learn to do. The first two queries which output into $cui1 and $cui2 take about an hour to select about 70 values. I do not want to execute that in another nested query. I would rather pass the result set as a parameter to the third query.

Thank you, I already have the CUIs in variables. My question is how do I send these values from the variables to the query. The code below does not work. What can I do to make it work? $cuis = mysql_query("SELECT CUI1,CUI2,REL FROM MRREL WHERE CUI1 IN $cui1 OR CUI1 IN $cui2 ");

The first two queries get a list of all CUIs - which are basically IDs of a certain string STY like xyz or abc. CUI is not the primary key in the MRSTY table. I need the results of this table. The third query is an "IN" subquery which basically sends the CUIs obtained in the first two queries as conditions. It is more like saying: Select name from employee where cafeteria_id in (select cafeteria_id from cafe where branch = "new york") or cafeteria_id in (select cafeteria_id from cafe where branch = "london") What I'm trying to do is perform the first two queries and store the results in a variable like: $cui1 = select cafeteria_id from cafe where branch = "london" $cui2= select cafeteria_id from cafe where branch = "new york" and then send the first two variables into the third query: Select name from employee where cafeteria_id in $cui1 or cafeteria_id in $cui2

I'm sorry, it doesn't work. Is there anything which accomplishes it in the same way without having to send the query in again?

Hi all, I'm new to php and I was trying to send the results of one query to another query. I need the results of both queries. Here are the queries $cui1 = mysql_query("SELECT DISTINCT CUI FROM MRSTY WHERE STY='ABC' "); $cui2 = mysql_query("SELECT DISTINCT CUI FROM MRSTY WHERE STY='XYZ' "); I want to know if this is possible $cuis = mysql_query("SELECT CUI1,CUI2,REL FROM MRREL WHERE CUI1 IN $cui1 OR CUI1 IN $cui2 "); Thanks.