SQL STATEMENT

<i><b>Originally posted by : Dana Williams (danaw@intel.com)</b></i><br />HI,<br /><br />I need your help in modifying the SQL Querey of the asptree provided in this site. <br /><br />I'd like to add a new field in the tblPages named U_ID(The Tree structure (tblCategory) will stay the same) . <br /><br />EACH TIME THE TREE LOADS THE QUERY SHOULD LOAD ONLY THE PAGES WITH THE USER ID.<br /><br />This is the SQL that comes with the tree <br /><br />strsql = "SELECT tblCategory.level, tblCategory.[ID], tblCategory.Sort AS CatSort, tblPages.sort AS LinkSort, tblCategory.[Name] AS CatName, tblCategory.HREF AS CatURL, tblPages.[Name] AS LinkName, tblPages.href AS LinkURL FROM tblCategory LEFT JOIN tblPages ON tblCategory.[ID] = tblPages.[ID] ORDER BY tblCategory.Sort, tblPages.sort"<br /> <br /><br />Probably I need to add a " WHERE..." statement somewhere, but I don't know what the LEFT JOIN means,<br /><br />PLEASE HELP! I don't have a clue on this.<br /><br />