In QGIS I am trying to join data from two postgis tables. I can not figure out how to do this at sql because add layer tools seem to allow one to select just one table to filter on. Instead I loaded all tables as separate layers and then used the join layers in the properties of one of the layers.
That worked but I end up with a lot of attributes that I don't need or want.
How do people handle this? One solution that occurs to me is to construct a view in postgres.