Fahmi

使用更新 JOIN

update TableA A
inner join tableB B on B.country_name = A.country_name
set A.country_code=B.Country_code

您必须立即使用()-now()-interval 30天-您使用的是SQL Server函数

$query = query("
SELECT count(CASE WHEN filter='冬越しする(現在地検索)' THEN 1 END) as filter, 
count(CASE WHEN filter='開花期で選ぶ' THEN 1 END) as filter2, 
count(CASE WHEN filter='日当たりで選ぶ' THEN 1 END) as filter3,  
count(CASE WHEN filter='株幅で選ぶ' THEN 1 END) as filter4,
count(CASE WHEN filter='背丈で選ぶ' THEN 1 END) as filter5, 
count(CASE WHEN filter='機能、タイプで選ぶ' THEN 1 END) as filter6,
count(CASE WHEN filter='ビギナーおすすめ' THEN 1 END) as filter7 FROM 
filter_clicked WHERE filter_date < date(now())-interval 30 day")

您可以尝试使用USER数据表的多个实例的连接

 SELECT g.id, g.guidUser1, u.username, g.guidUser2 u1.username as username2
    from 
    games g inner join userdata u on g.guidUser1=u.guidUser
    inner join userdata u1 on g.guidUser2=u1.guidUser

你可以在下面试试

SELECT vt_clients.cl_id , vt_clients.cl_name_last 
FROM vt_clients 
WHERE not exists
(SELECT 1  
FROM vt_animals an WHERE an.cl_id=vt_clients.cl_id and an_type IN('snake', 'lizard', 'turtle') 
having COUNT(an_type) >= 1
)

你可以在下面试试-

update tableB A 
join 
(select * from tableA x where ymd in (select max(ymd) from tableA x1 where x.eno=x1.eno)
)B on A.eno=B.eno
set A.target=B.target

你必须把 t1.collection_date <= '2019-02-09' 至于作业ID 1002日期是 '2019-02-09'

SELECT  t1.id,
        t1.collection_date,
        t2.order_date,
        t2.hasOrders
FROM job_details AS t1
    LEFT JOIN
        (
        SELECT  job_id, 
                MAX(date) AS order_date,
                (CASE COALESCE(MAX(date), '0000-00-00') WHEN '0000-00-00' THEN 'false' ELSE 'true' END) AS hasOrders
        FROM sales_orders group by job_id
        )
    AS t2
    ON t2.job_id = t1.id
WHERE t1.collection_date <= '2019-02-09'

你可以用 JOIN

SELECT b.name,userid,COUNT(*) as nbr_entries FROM info a
inner join generic b on a.userid=b.id
GROUP BY b.name,userId 
ORDER BY nbr_entries DESC;