MS SQL query
Posted on 2013-01-27
SQL is pretty new for me coming from MS access how do I do this?
I have 2 related tables
Table 2 [ActionsOnJobs]
What i'm trying to get is a list of all the jobs with the most recent Action title that is LIKE '%phone%' and the date of that phone call.
I assume I use a group by with MAX to find the most recent one and LIKE '%phone%' but, I cant seam to get a single record from Table 2 that represents gives me the answer, below. What I would like to see is below (note there are many phone calls for job ID 10 but 26/1/13 is the most recent)
Job JobTitle ClientID JobOpenDate JobCloseDate ActionTitle ActionDate
10 Big Job 5500 1/1/2012 NULL Phone call 26/01/13
Thanks in advance