I am using OS Ticket and I have another site for Members Area,I
am trying to join the 3 tables that have the information that corresponds to the customer by EMAIL.
the first table is:qbcd_ticket: ticket_id | number | user_id | user_email_id | status_id | dept_id | and more... 5 | 762086| 2 | 0 | 1| 1 | the next is qbcd_user_email rows: id | user_id | flags | address 2 | 2 | 0 | firstname.lastname@example.org the last is: qbcd_user id | org_id | default_email_id | status | name | created | updated 2 | 0 | 2 | 0 | Customer Name | 2017-03-03 10:44:28 | 2017-03-03 10:44:28
The information that I need to display, is all corresponding Tickets associated with the customer where it = the email address.
The database connection and display is something I can do, however, I do not know how to perform an interjoin or a join request.
the only static variable that will not change is $_SESSION['user_email']; which is logged by logging into the members area.
If you can assist me with this that would be great.