Please only bid if you are SQL EXPERT as i have only a short time to complete
I have a small SQL project to write a bit of code to extract some data from a diary system.
What I need to do is use two tables:
Table 1: Holds information on helpdesk calls. From this table I need the script to find all records which are still active.
Table 2: Holds all of the diary updates for the calls. From this table I need to fetch the LAST record associated with the ACTIVE calls in table 1 and give me some information about those records
I have got the basics of the script but it returns duplications so I need someone who can update it or create a new one without these duplications.