查询从两个不同的表中获取数据

Question

I have two tables. Table A and B. I have a log-in form where I will get the username,password, assign, assign2 of the user from table A and fetch data depending on the user's assign1 and assign2 from table B.

How my query would look like? Looking for answers. Thankyou so much.

Table A -THIS IS THE TABLE FOR LOG-IN FORM
==========================================
username | password | assign1 | assign2 |
------------------------------------------
SANDRA   | SANTOS   |    1    |   1     | //Values
--------------------------------------------

Table B - 
=======================================

name | assign1 | assign 2 |
------------------------------
DADA |  1      |   1      |  //this will be displayed
------------------------------
gorg |  2      |    2     | 

//this must not be displayed since the user assign1 and assign2 who logged in did not match to this

Answer 1

You are using $sql variable in

$result = $con->query($sql);

It should be $queryagain.