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,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
Regards,