SQL requirements:
We have an Access 2003 database with an SQL 2000 server database.
We require an SQL query or procedure to collate data by customerID from multiple records in faultlog table and create a single record per customerID in JOBDATA table.? Then if necessary, create an INVOICE per job.