I am trying to show data on a datalist, but with some caveats.
1. WHERE the User Id = the querystring id pass on the url
2. WHERE the table 'resume', the 'permissions' column shows as '1'
WHERE the table 'resume' the 'permissions' column contains within it any number from 2-4, any of which matches one or more numbers in the 'permissions' column of the 'contacts' table (but WHERE the 'contacts' table where the url querystring id = column 'myuserid' and the signed in Profile.UserName = the column 'theiruserid'
Its complicted, but i dont know how to reference another data table when selecting data from the first table...?
Thanks if someone can help!
View Complete Post