Join 1 table more than once - not working

Hi,Sirs,

#Classic
I was trying to join 1 table Users twice but the IDE pickups only the 1st one. Please see attached photo.

Thanks,

Hi @jp26198926,
Please note that if you want to make complex queries like what you explained above, you have to create a database view instead, as it is difficult for radsystem to handle such a statement. you are better off using join to a table once or creating a database view to join a table more than once and have their fields appear, thanks.

Regard,
willvin

Hi @willvin ,

Thank you for the suggestion.

I was just testing the feature of phprad 7.2.3 if still doable in this new version :smiley:

Regards,