Noob here.
I'm trying to pull info from 2 tables that have a same id reference.
tbl_users
emp_no
first_name
last_name
email
sup_id
tbl_sups
sup_id
sup_name
sup_email
I've tried many different query statements.... (not at the same time...)
$query="SELECT emp_no, first_name, last_name, email, sup_id FROM tbl_users, tbl_sups WHERE tbl_users.emp_no=$emp_no && tbl_users.sup_id=tbl_sups.sup_id";
$query="Select * from tbl_users.emp_no, tbl_users.first_name, tbl_users.last_name, tbl_users.email, tbl_users.sup_id, tbl_sups.sup_id, tbl_sups.sup_name, tbl_sups.sup_email where tbl_users.emp_no=$emp_no and tbl_users.sup_id = tbl_sups.sup_id";
$query="Select tbl_users.first_name, tbl_users.last_name, tbl_users.email, tbl_users.email, tbl_sups.sup_id, tbl_sups.sup_name, tbl_sups.sup_email from tbl_users, tbl_sups where emp_no=$emp_no and tbl_users.sup_id = tbl_sups.sup_id";
The emp_no is called from a $_POST.
I could use some direction here. Thanks
