Comment by SlackingOff123

5 months ago

I agree. I also wish it was possible to run multiple queries in the same window e.g.:

  select * from crime_scene;
  select * from suspects;

1 comment

SlackingOff123

    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.