I have a query that pulls together data from multiple tables based on an ID that . The ID may have one record relating to it, it may have many. The query should only output the FIRST record for each ID number i.e. one row per ID number, despite how many other records may rleate to it. Is this possible?