This question already has an answer here:
I have two tables A & B.
id | name | num
id | date | roll
id in table B is a foreign key which relates to the id in table A.
I want to get the contents of table B where id is given and also along with that data, I need the name whose id is given from table A.
I did google and found out some weird keywords LEFT, JOIN but I couldn't understand it.
I need to get date and roll from Table B and name from table A in a single query. (id is a foreign key)
The plugin I am using sadly doesn't allow multiple queries separated by commas so I need to do both the
SELECTs in one query.