How to use MySQL UNION in qa_db_query_sub function?

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

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:
Russia and Ukraine agree local truce to allow repairs at Europe’s largest nuclear power plant
Opinion: Block's layoffs might just be the biggest story of a tumultuous week. Here's why
UBS downgrades the U.S. stock market. Here's what has the investment bank worried
U.S. and Iran wrap up 'most intense' nuclear talks with no deal — more negotiations ahead
Jim Cramer's top 10 things to watch in the stock market Friday
OpenAI announces $110 billion funding round with backing from Amazon, Nvidia, SoftBank
The Strait of Hormuz is facing a blockade. These countries will be most impacted
Frieren: Beyond Journey's End: A Demon-Slaying Request
Special Event: Taylor Tomlinson: Prodigal Daughter
Book: finnegans wake