requete :SELECT client.id, DAY(date) as d, DAYNAME(date) as d2, prix, extra, vente, method, emethod, vmethod, remise, client.nom, status FROM rdv
JOIN chien ON chien_id = chien.id
JOIN client ON client_id = client.id
WHERE MONTH(rdv.date) = 8 and YEAR(rdv.date) = 2022 AND status = 1 ORDER BY date, client.id asc
erreur:1146=>Table 'scoobydomicharly.rdv' doesn't exist
Stats 2022 8
| date |
nom |
tarif |
extra |
vente |
remise |
Total |
| Total |
0 |