Hey Folks, I have a query that seems like it will never end. I'm hoping you can help me rewrite it.
I have 4 tables that contain information about house sales within the state (sale, taxes, property, buyer). Each table has an 'id' field that links each record. I am just trying to flatten these files so I will have all of the information in a single file. Below is my attempt to do so. Is there a more efficient way to rewrite the joins? select * from sale, taxes, property, buyer where sale.id = taxes.id and sale.id = property.id and sale.id = buyer.id I'm using postgresql 8.3 on a Windows 7 machine. Thank You, -Tripp -- View this message in context: http://www.nabble.com/Rewrite-multiple-joins...-tp25073534p25073534.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
