← Back to team overview

dhis2-devs team mailing list archive

User queries on Users table

 

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

References