Thanks !  all tables have different structures and when i use the query designer i get duplicate values cause i guess it uses cross joins where as it it should...