Can someone please help me with this access query? Walker Requests Customer Dog
ID: 3716267 • Letter: C
Question
Can someone please help me with this access query?
Walker Requests Customer Dog 1 Oo Walker ID Last Name First Name Street Address Request ID Customer ID Walker ID Date Start Time Length Customer ID Last Name First Name Street Address Customer ID Dog ID Name Date of Birth Breed Weight Height State ZIP Home Phone Cell Phone Email Address Experience with large dogs? Insured/Bonded State Zip Home Phone Cell Phone Work Phone Email Address Credit Card Number Expiration Date CCV Code Lockbox Insured/Bonded?Explanation / Answer
Kindly adjust the table and column name accordingly.
SELECT WALKER.FIRST_NAME,WALKER.LAST_NAME,DOG.NAME FROM WALKER INNER JOIN REQUESTS ON WALKER.WALKER_ID = REQUESTS.WALKER_ID INNER JOIN CUSTOMER ON REQUESTS.CUSTOMER_ID = CUSTOMER.CUSTOMER_ID INNER JOIN DOG ON CUSTOMER.CUSTOMER_ID = DOG.CUSTOMER_ID WHERE ((SELECT DATEDIFF(DAY,DOG.DATE_OF_BIRTH,getDate()))/365.25) > 8;