well the problem is is
i had made all of my links that i could make
my ultimate resolution to this problem was doing a
"group by" statement and grouped it by a few of the
items in my original statement.
i was createing a view and was trying to get the select statment to work
only problem im having now is that when i do a
select * from (view name)
it henders performance of the database
I'm nearly certain that you could adjust your JOIN operations to fix the underlying problem. This would give you the best overall performance, since you wouldn't be using server resources to construct useless rows in your result set, then using more server resources to group the rows to remove the useless rows. This strikes me as just a waste.
The time needed to fix the problem might be more than the problem is worth. If you'll only use this code once, the time needed to fix it is probably more expensive than the resources the code will waste. However, if you are going to use the code repeatedly, the balance tends to tip toward making a fix more economical in the long run.
It is your call to make, but I'd recommend fixing the JOIN instead of GROUPing to hide the problem.