Inner join syntax

 

......................................................................................................................................................................

/* The table 1 has XX rows

   the table B has YY rows*/

Select * from "<Drop and Drop table 1 from HDI>" as A

Inner join "<Drop and drop table 2 from HDI>" as B

On A."<Foreign_key name of table A>" = B. "<Foreign_key name of table B>"

....................................................................................................................................................