join query

[eluser]Sean Murphy[/eluser]
Ah, sorry. I overlooked the fact that you were using an inner join.

This might help you to understand joins: http://www.codinghorror.com/blog/archives/000976.html

[eluser]A.M.F[/eluser]
thank u guys!