---------- Forwarded message ---------- From: Juma Lungo <[email protected]> Date: Fri, Dec 4, 2015 at 9:44 AM Subject: [Dhis2-devs] User queries on Users table To: DHIS Developers <[email protected]>
Hi on DHIS2 v2.16, I cannot save the following query, ===== SELECT surname, firstname, phonenumber, username FROM userinfo INNER JOIN users ON (userinfoid = userid) ===== because I am querying "special tables". What is the workaround for this? Lungo _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Knut Staring Dept. of Informatics, University of Oslo Norway: +4791880522 Skype: knutstar http://dhis2.org
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
