have 3 tables: event, type, venue. A venue can have many events over time, an event will be of a certain type. So relationships exist between the 3 tables and this is represented by FK's. I wish to populate a user form with data such as a list of all available venues, all available event types, a query - along the line of -
SELECT venue.venues, type.types FROM venue, type
This will result in a horrendous cartesian join that will add to network traffic. Is there a way to retreive this data whilst avoiding this? The selection of all venues and all types is in no way conditional upon the relationships between the tables. Should I set this up as two seperate queries to avoid the overhead of the join?
SELECT venue.venues, type.types FROM venue, type
This will result in a horrendous cartesian join that will add to network traffic. Is there a way to retreive this data whilst avoiding this? The selection of all venues and all types is in no way conditional upon the relationships between the tables. Should I set this up as two seperate queries to avoid the overhead of the join?