How to use MySQL UNION in qa_db_query_sub function?

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

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:
Anthropic will be 'most ridiculous IPO' of year, analyst says
Supertanker chartered from Gulf Coast to China for $76 million, 10 times higher than pre-war level
SpaceX’s plans to buy more Nvidia GPUs is keeping Jim Cramer bullish on the chip stock
Inside India newsletter: Food crisis, economic shock ahead as India braces for El Niño
FCC to vote on auctioning 25MHz of 'prime spectrum' in move that could benefit Amazon, SpaceX
Online, self paced computer skills class for TOTAL beginner?
Slow Horses: Lost and Found
Line of Fire: Pilot
Movie: Verity
Elon Musk blames Indian 'oligarchs' for stalling Starlink launch