How To Join 2 Tables of database and fetch data.

$sql = "select * from movie join screen on movie.screen=screen.id";

Description : 

Select data from movie table and(join) screen table on movie(table) . screen(field) = screen(table) . id(field) 

and then fetch data from table.

And If field name - (name) same in both join table (movie and screen).

then we create join query as below

$fatch = "select *, screen.name as sc_name from movie join screen on movie.screen=screen.id";

in above query we save field velue after select * , screen.name as sc_name 

means name field of screen table as Sc_name

then print sc_name in fetch data table in admin panel.