Sopheon interview question

Write an example of a JOIN statement in SQL.