Joins

hi
i know the concepts of joins in database, please can you help me to get the examples which will help to get the clear picture of joins in database