Hi

Im wondering if its possible to do what I want to do all in one query - Im guessing it is because i dont think its that complicated but its too complicated for me to figure out anytime soon.

I've got two tables, equipment and services:
Each equipment may have several services, and these services might be past services or upcoming services. There is a column in the services table `upcoming` which if set to 1 tells you that it is an upcoming service and if 0 a past service.

I want to select all from equipment, and along with each row select the date of last service and the date of the next upcoming service.

Code:
table `equipment`
`equipmentid`, `name`, `otherdetails`

table `services`
`serviceid`, `equipmentid`, `date`, `service_description`,`upcoming`
Bear in mind though that a certain equipment may not have any past services or it may not have any upcoming services.

Thanks!