Is it possible to select 2 tables with an inner join with some equal columns with 1 WHERE clause for the 2 tables?
Example: Table user: fam_id, fam_status, Table user_child: fam_id, fam_status
SELECT * from user INNER JOIN user_child ON user.fam_id=user_child.fam_id WHERE fam_id=14
Will this select the rows from Table user and Table user_child?