Hello everybody,
I have a problem while I am trying to execute multiple query in a statement.
My query like that
- DROP TABLE IF EXISTS query;
-
CREATE TEMPORARY TABLE query SELECT Separations.ID,Name,Separation_Method,OrganismID,Date,Image,Description
-
FROM Separations;
-
-
DROP TABLE IF EXISTS login;
-
CREATE TEMPORARY TABLE login SELECT Separations.ID,Name,Separation_Method,OrganismID,Date,Image,Description FROM Separations WHERE ID IN (SELECT a.RowID FROM Access AS a INNER JOIN Groups AS g ON a.GroupID=g.ID INNER JOIN Members AS m ON m.GroupID=g.ID INNER JOIN Users AS u ON u.ID=m.UserID WHERE u.Email='null' UNION SELECT a.RowID FROM Access AS a INNER JOIN Groups AS g ON a.GroupID=g.ID WHERE g.Name='Guests');
-
-
SELECT * FROM query INNER JOIN login ON query.ID=login.ID;
The problem is when I use stat.executeQuery() this query, it returns null to ResultSet. But this sql query returns 15 rows when I execute in Mysql tool. How can I solve this problem?
