Simple ideas and quickly what you need to find to write a query for joining of two tables explained.
In this post, I have answered one tricky SQL-view interview question. Views availability after the base table modified confuses many developers. I provided an answer to this.
I have explained on how to give multiple conditions in the SQL WHERE clause with examples
Explained examples on SQL Right and Left functions to handle Strings and to get Substring correctly.