Problem with jointing via UNION , UNION ALL

please do not take this the wrong way, but i don’t think i can help you any further with this project

it is getting ~way~ too complicated for a forum discussion

i hope that i have helped you in debugging your SQL, and that you have learned something along the way

Ok , that is a complicated project ; I hope that they would be just some simple bugs because I`m fear that all problems are drived from missing some important philosophies like “GROUP BY and HAVING with Hidden Columns” that can astound me for long days .

Again thanks for your good support .

Regards
Omid