Que tal tengo esta consulta:
SELECT r.remark_id, r.contact_id, r.sent_by, r.agreement_type, DATE_FORMAT(r.date,'%%m/%%d/%%Y') as date,
DATE_FORMAT(r.receipt_date,'%%m/%%d/%%Y') as receipt_date, r.next_comun,
CONCAT(c.title,' ', c.first_name,' ', c.last_name) as contacto, c.position, DATE_FORMAT(a.date,'%%m/%%d/%%Y') as next_date
from remarks r, provider_contacts c, agenda a
where a.remark_id=r.remark_id AND r.provider_id = 47 AND type_2='status' AND r.contact_id=c.provider_contact_id
Pero necesito pasarla a RIGHT JOIN para que me muestre todos los registros aunque no tengan un registro correspondiente en a.remark_id=r.remark_id
Estoy intentando esto pero no me sale:
SELECT r.remark_id, r.contact_id, r.sent_by, r.agreement_type, DATE_FORMAT(r.date,'%%m/%%d/%%Y') as date,
DATE_FORMAT(r.receipt_date,'%%m/%%d/%%Y') as receipt_date, r.next_comun,
CONCAT(c.title,' ', c.first_name,' ', c.last_name) as contacto, c.position, DATE_FORMAT(a.date,'%%m/%%d/%%Y') as next_date
from provider_contacts c
RIGHT JOIN (remarks r RIGHT JOIN agenda a ON (a.remark_id=r.remark_id) AND(r.provider_id ='47') AND(type_2='status') AND(r.contact_id=c.provider_contact_id))
Agradezco la ayuda. Saludos.
