Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Marclem's latest activity
-
Marclem replied to the thread javascript:navigator.registerProtocolHandler.I was able to get it working and providing json code below to help anyone with this issue in the future: { "$schema"...
-
Greetings, I am trying to auto-populate an email content to auto create an email. I am using Microsoft Lists (I am not a programmer)...
-
-
Marclem replied to the thread Joining 4 tables issue.I see:(... Trying to understand which table I can get the user roles from to show up as shown from the system's front-end: As you can...
-
-
Marclem replied to the thread Joining 4 tables issue.Attached the results from your query: Select sf_user_id From st_user Where sf_user_id NOT IN (Select sf_user_id From st_useraccount_roles)
-
Marclem replied to the thread Joining 4 tables issue.Adding r.sf_role_id to the end of the Select statement still got me "null" values. Basically as shown below tables st_useraccount_roles...
-
-
Marclem replied to the thread Joining 4 tables issue.Thank you Andy, I ran your query and got 0 results, but if do and left join I get data but again the r.sf_name shows "null" values.
-
-
Marclem replied to the thread Joining 4 tables issue.Thank your for your reply Ian, I am not quite sure if these tables have foreign key constraints. Basically the first 3 tables I can...
-
-
Greetings, I have below query which I am trying to get the last table named st_role column st_role.sf_name data but I am getting "null"...
-
Greetings, I have below query which I am trying to get the last table named st_role column st_role.sf_name data but I am getting "null"...
