SELECT ROLODEX.DOB, ROLODEX.PHONE1, ROLODEX.SS,
RTRIM(Rolodex.firstname) + ' ' + RTRIM(rolodex.lastname)
RTRIM_Rolodex_lastname_R,
DAYOFMONTH(rolodex.dob) DAYOFMONTH_roldex_birth, MONTHNAME(CURDATE()+(32 - DAYOFMONTH(CURDATE())) MONTHNAME_CURDATE, ROLODEX.ADDRESS, ROLODEX.ADDRESS2, RTRIM(rolodex.city) + ', ' + rolodex.state + ' ' + LEFT(rolodex.zipcode, 5)
RTRIM_city_state_zip
FROM MATTERS MATTERS, RELATED RELATED, ROLODEX ROLODEX
WHERE MONTH(rolodex.dob) = MONTH(CURDATE()) + 1 AND (Related.ID = Matters.MatterID) AND (Rolodex.Deceased is NULL) and (Rolodex.Ident = Related.Related) AND ( (Related.Client = 1 ))
ORDER BY 5,4 |
|
|
|
|
|
| User Opinions |
|
| No users have voted. |
|
| How would you rate this answer? |
|
|
|
