Report question

Question: In SQL, is it OK for two tables to refer to each other?