troubleshooting Question

sql for mysql explanation of the sysntax SELECT vtiger_crmentity.*

Avatar of sydneyguy
sydneyguyFlag for Australia asked on
DatabasesMicrosoft SQL ServerMySQL Server
3 Comments2 Solutions435 ViewsLast Modified:
am modifing the sql below and have not seen the code SELECT vtiger_crmentity.* before and am guessing that it does the same as select * from ect but am trying to get this to run in access where i have buitl through an odbc interface but it does nto seem to like it any ideas

it works perfect in sqlylog a mysql native editor

SELECT vtiger_crmentity.*, vtiger_projecttask.*, CASE WHEN (vtiger_users.user_name NOT LIKE '') THEN
 vtiger_users.user_name ELSE vtiger_groups.groupname END AS user_name FROM vtiger_projecttask INNER JOIN
 vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_projecttask.projecttaskid INNER JOIN vtiger_project ON
 vtiger_project.projectid = vtiger_projecttask.projectid LEFT JOIN vtiger_users ON =
 vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros