Hi All,
I am creating an rental application for three types of users, including tenants, agencies and admin. After they login, they should land on different pages e.g. tenant will be redirected to page 2, agency will be redirected to page 3. I created a LOGIN table with user_name, password and roles. I found some solutions online about adding a branch on Page 1 (Home page), but I am struggling with writing the SQL query. Thanks in advance for helping me out.