Comment by sgarland

    SELECT
      cs.*,
      s.*
    FROM crime_scene cs
    FULL JOIN
      suspects s ON cs.id = s.id;

This maintains zero relationship between the tables, of course, but it shows you both. You could also specify individual columns.