SELECT [CADET_NO], [dbo_RifleInventory].[PEOPLE_ID], [SERIAL], [SLOT], [TROOP], [DRILL_TEAM], [JR_OR_SR], [DORM_ROOM], [DORM_PLAN], [PREVIOUS_ID], [FIRST_NAME], [MIDDLE_NAME], [LAST_NAME], [dbo_PEOPLE1].[PEOPLE_ID]
FROM RifleInventoryQuery;
FROM RifleInventoryQuery;