How to use MySQL UNION in qa_db_query_sub function?

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

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:
Which credit card should you pay off first? 5 tips to help you decide
Bitcoin faces pressure after hotter-than-expected inflation data: CNBC Crypto World
Iran war poses challenges to high-margin Middle East car market
Odds of a Fed rate hike by June are now higher than the chances for a rate cut
Top Chef: Puckerbutt
Special Event: The 98th Academy Awards, 2026
Micron revenue almost triples, tops estimates as demand for memory soars
Bank of Japan keeps rates steady as expected, warns Iran war may push up inflation
Vice President Vance to meet with oil industry as White House plans more actions to address fuel prices
These income-generating plays can yield up to 6% as the Fed holds rate steady