Hi,
I have three tables
1) A list of devices
2) List of rooms
3) A bridge table that relates the two using each table's ID column
Any device can be in 0 to All rooms
I want to create a view that joins both tables that in includes all
columns from all 3 tables.
I'm not sure how to link joins in the Postgres SQL syntax. I'm more used
to the =* one.
I want to do something like
SELECT (explicit list of all tables columns - didn't like * but was ok
with actual list)
FROM
devices,rooms,bridge
WHERE
bridgeroomid = rooms.id
AND
bridgedeviceid=*devices.id
so that devices with no associated rooms would have null values for
those columns but be listed.
Any advice appreciated.
KDT