Basic python and pandas interface with SQL. For the simplicity, we are going to SQLite. The basic principle should be the same across different DBMSs.
There are more than Left and Inner join. However SQLite only support Left and Inner Join. There are also Right and Full (Outer) Join. Which the principle is the same as Left Join.