How to use MySQL UNION in qa_db_query_sub function?

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

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:
Watch Fed Chair Jerome Powell testify live before Senate banking panel
Sales of new homes tanked in May, pushing supply up to a 3-year high
What would you have done, baby bird question #62
Microphone doesn't work in Chrome when using FB Messenger
Answered: [New Free Plugin] : Points to the users on each Activeday
California Gov. Gavin Newsom sues Fox News for $787 million, alleging defamation
Supreme Court upholds Texas adult website age-verification law
What we know so far about Jeff Bezos' $50 million star-studded luxury Venice wedding
Congress' 'big beautiful' bill proposes new Medicaid work requirements. Here's what to know
Google is primed for significant gains ahead. Using options to capture the potential pop