How to use MySQL UNION in qa_db_query_sub function?

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

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:
Trump's 'big beautiful bill' has a 'double taxation' trap for top earners, tax lawyers say
SoftBank shares plunge over 11% amid broader tech sell-off
Senate GOP strips up to $1B for Trump ballroom security from immigration enforcement bill
What should I do with a free day in Paris?
Don't Want No Scrub (Jay)s
I want control of my Keyboard Shortcuts (Windows)
Widow's Bay: Your Baggage
Book: Dungeon Crawler Carl Book 8: A Parade of Horribles
Stargate SG-1: Between Two Fires Rewatch
Eli Manning weighs in on Giants QB Jaxson Dart's Trump rally fallout