How to use MySQL UNION in qa_db_query_sub function?

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

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:
Fed's Kashkari says 'now is the time to start slowly moving' rates up
Lucid stock plunges as EV maker begins 'operational reset,' delays midsize vehicle
Manager of DRAM memory chip stock trade blockbuster ETF is back with new AI thematic bet
SpaceX moon crash is a perfect metaphor for rocket maker’s share price, analysts say
Abdul El-Sayed wins Michigan Democratic Senate primary as voters pivot to the left
Trump admin refunds $100 billion in 'liberation day' tariffs
Silo: Memory Show Only
Disney tops earnings estimates as parks and streaming offer a boost
Hollow wall anchor
Movie: The Temptation of St. Tony