why cant I more than two values from 3 different tables in one query

Question

This is strange. In the news details page, I want to take a few different values from different tables with one query. However, for some strange reason, I only get two values back. So the outcome is like:

<Desc></Desc>
<Date/>
</row>
</rows>

If I disable fullname, then I get shortdesc but not others. Same things happens with others.

NewsID = Request.QueryString("NEWSID")  

SQL = "SELECT N.NewsID, N.MembersID, N.CategoriesID, N.ImagesID, N.NewsTitle, N.NewsShortDesc, N.NewsDesc, N.NewsActive, N.NewsDateEntered, C.CategoriesID, C.CategoriesName, M.MembersID, M.MembersFullName"

Set objViewNews = objConn.Execute(SQL)  

With Response
    .Write "<?xml version='1.0' encoding='windows-1254' ?>"
    .Write "<rows>"
End With

With Response
    .Write "<row id='"& objViewNews("NewsID") &"'>"
    .Write "<FullName>"& objViewNews("MembersFullName") &"</FullName>"
    .Write "<CategoryName>"& objViewNews("CategoriesName") &"</CategoryName>"
    .Write "</row>"
End With

With Response
    .Write "</rows>"
End With    

objViewNews.Close
Set objViewNews = Nothing