Forums

hi all,

I am having a bit of an issue with getting a join rule to work.
form addclients is used to set up clients and once known assign client manager to them
table cf_data_clients is used for client data and shall be joined with users table
form listclients is supposed to list all clients incl their respective manager

using

INNER JOIN #__users AS Users ON Manage_Clients.im_uid = Users.id

only lists those clients with assigned client manager

using

Manage_Clients.im_uid =
 CASE WHEN
   Manage_Clients.im_uid != 0
   THEN Manage_Clients.im_uid = Users.id
   ELSE 0
END

lists only those clients without assigned client manager

could s.b. pls point out to me what I'm doing wrong?

J2.5.9; CF4.0 RC3.5.2

Hi gabrielaH,

Please see this SitePoint tutorial. I think you need a LEFT JOIN here.

Bob

hi Bob,

thanks for getting back to me on that matter.
your suggestion works :-)