Avatar of sydneyguy
sydneyguy
Flag for Australia asked on

sql for mysql explanation of the sysntax SELECT vtiger_crmentity.*

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_users.id =
 vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid
MySQL ServerMicrosoft SQL ServerDatabases

Avatar of undefined
Last Comment
sydneyguy

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
JestersGrind

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
barlet

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
sydneyguy

ASKER
thanks access changes it to what it is above and redoing the syntax as it is built thanks for the help
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck