SELECT cs.*, s.* FROM crime_scene cs FULL JOIN suspects s ON cs.id = s.id; This maintains zero relationship between the tables, of co

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.