Tried working with the data you provided and it's a mess. Could you please post table definitions and insert statements for your data? Then those trying to help will be dealing with your data as it is, not just their best guess.