Rewrite multiple joins...

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.