How to use MySQL UNION in qa_db_query_sub function?

Post date: 2020-08-11 05:24:21
Views: 128

Although it seems that qa_db_query_sub function will be deprecated in Q2A 1.9.0, but still I would like to ask how to use MySQL UNION in qa_db_query_sub function?

This simple SELECT function works well

SELECT postid FROM  `qa_posts`  WHERE `type`="Q"  ORDER  BY created DESC  LIMIT  1

qa_db_read_all_assoc(qa_db_query_sub('SELECT postid FROM  `qa_posts`  WHERE `type`="Q"  ORDER  BY created DESC  LIMIT  1'));

But this compound function doesn't work:

SELECT postid FROM  `qa_posts`  WHERE `type`="Q"  ORDER  BY created DESC  LIMIT  1 UNION ALL SELECT postid FROM  `another_posts`  WHERE `type`="Q"  ORDER  BY created DESC  LIMIT  1

Or even this doesn't work either

(SELECT postid FROM  `qa_posts`  WHERE `type`="Q"  ORDER  BY created DESC  LIMIT  1) UNION ALL (SELECT postid FROM  `another_posts`  WHERE `type`="Q"  ORDER  BY created DESC  LIMIT  1)

qa_posts and another_posts have the same structure in this example.

Please click Here to read the full story.
 
Other Top and Latest Questions:
Best cash management accounts of May 2024
Major corporations reluctant to make a splash at the 2024 political conventions
'Trader justice': Ex-SocGen trader fired for risky bets claims he was made a 'scapegoat'
U.S. job growth totaled 175,000 in April, much less than expected, while unemployment rose to 3.9%
Movie: Alice
Social Security now expected to run short on funds in 2035, one year later than previously projected, Treasury says
Will China's comeback stock rally last? Wall Street weighs in and shares stock picks
'Twist' in Warren Buffett's succession plan raises eyebrows among Berkshire's Omaha faithful
Frieren: Beyond Journey's End: Perfect Replicas
Movie: Creepshow