Gerry is right - that SQL is very hard to read.
But even formatted for readability, we probably can't help you as it stands: we have no idea what the relationship between the two tables is, and that's pretty much essential to actually fetching the data you want.
But in all likelihood, what you will need is a JOIN of some type (and it would probably improve the quality of your original query as well - but we have no idea of your data or what output you are trying to get so we can't be sure).
So it's time for some reading:
SQL Joins[
^]
Oh, and do everyone a favour:
DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalization if you want to be taken seriously.