Hi, I'm trying to use a WITH clause in a query but keep getting the message ORA-00942: table or view does not exist I've tried to create a simple query just as an example here: WITH test AS ( SELECT COUNT(Customer_ID) FROM Customer ) SELECT * FROM test; But even this dosen't work, it just gives the message: SELE...
I am converting all my MSSQL queries to mysql and my queries that has "with" in them are all failing with t1 as ( SELECT article.*, userinfo.*, category.* FROM question INNER JOIN userinfo ON userinfo.user_userid=article.article_ownerid INNER JOIN category ON article.article_categoryid=category.catid WHERE article.ar...
Hello! The object of my query is to search for a long string in a database. To speed up this process, all records of the longstring table have a hash of that string on the same record. I want to first find all records in the table where my search string's hash is equal to a hash on the longstring table. Then after I have that dataset, I...