Hello.
Working on a trouble ticket database.
I have a query which generates system id numbers.
// build open ticket query
$query = "SELECT trouble_ticket.systemID ";
$query .= "FROM trouble_ticket INNER JOIN users ON (trouble_ticket.userid = users.userid) ";
$query .= "WHERE trouble_ticket.status =1";
Is it possible to take those systemID numbers and query those into the systems table (with the same room id numbers) to then get the room id names?
I mean, I know it is possible, but how do I do it?
// get room information for system
$query2 = "SELECT systems.room INNER JOIN trouble_ticket ON (systems.systemid = trouble_ticket.systemID";
Instead of the an INNER JOIN on the trouble_ticket table, it should inner join onto the results of the first query, right? But how?
Thanks for any and all assistance. Sorry for my poor coding skills -- I am a graphic artist roped into doing the website programming!
slipster70
