GOLDPoint Systems interview question

Given 2 small SQL tables, write a simple JOIN statement to get certain rows from each table