I have job and task tables. Multiple tasks per job - one to many. Each task has a date. if any task date is the current date, I want a query that will return all data in a job record, with an additional column that indicates that there is a task scheduled for the current day and a column that returns that task date.
How can I do this?