Answer the question
In order to leave comments, you need to log in
How to combine 2 SQL queries into 1?
There are 4 MYSQL queries, I will give an example of two, I think by analogy I will do with 4.
SELECT COUNT( `id` ) AS `lll` FROM `link_base` WHERE `create_date` = CURDATE()
SELECT COUNT( `id` ) AS `aaa` FROM `ad_base` WHERE `create_date` = CURDATE()
Answer the question
In order to leave comments, you need to log in
SELECT
(SELECT COUNT( `id` ) FROM `link_base` WHERE `create_date` = CURDATE()) AS `lll`
(SELECT COUNT( `id` ) FROM `ad_base` WHERE `create_date` = CURDATE()) AS `aaa`
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question