Hi

thank you for your response

In your last part of the query i dont get what this is meant to do

I understand you want me to select certain columns/titles.

but the on query2.somcolumns is confusing me

SELECT WhateverYouWant

FROM Query1

INNER/LEFT OUTER/FULL OUTER JOIN Query2

ON Query2.somecolumns = Query1.somecolumns

ORDER BY SomethingMeaningful

--------------------------------------------------------------------------------