รบกวนด้วยค่ะ เรื่องเกี่ยวกับการดึงข้อมูลมาแสดง ตามเงื่อนไขของวันที่ค่ะ

mysql_query

("select count(*) 
from user,dead 
where DATE_FORMAT(dead.dead_inform,'%Y-%m-%d')   >  DATE_FORMAT(user.register_date,'%Y-%m-%d')   ");

select * from from user,dead,payment where DATE_FORMAT(dead.dead_inform,'%Y-%m-%d') > DATE_FORMAT(user.register_date,'%Y-%m-%d' and user.user_id=dead.user_id and dead.dead_id!==payment.dead_id

select user.user_id from user as u
inner join dead as d
on u.user_id = d.user_id
inner join payment as p
on d.dead_id != p.dead_id
where d.dead_inform > u.register_date

select * from user.user_id from user as u inner join dead as d on u.user_id=d.user_id inner join payment as p on d.dead_id != p.dead_id where d.dead_inform > u.register_date

mysql_query("select * from user,dead where datediff(dead.dead_inform,user.register_date)>0 and user.user_id=dead.user_id");

from user  inner join dead on user.user_id=dead.user_id inner join payment on dead.dead_id != payment.dead_id where dead.date_inform > user.register_date

select * from  user  inner join dead on user.user_id=dead.user_id inner join payment on dead.dead_id != payment.dead_id where dead.date_inform > user.register_date

SELECT* 
FROM bill 
INNER JOIN payment ON bill.bill_id = payment.payment_id
WHERE bill.bill_status <> '2'