Hi Rudy.
Thanks for your timely help and sorry for not responding earlier. The
problem was indeed with indexing. The moment I created the right
indexes, it showed the result in less then a second.
Amrit
rudy wrote:
here's the query you submitted, re-written to be slightly less insanely
diff
here's the query you submitted, re-written to be slightly less insanely
difficult to read (no offence to you personally, but how you, and so many other
people like you, can work like that, i'll never know) --
select contacts.first_name
, contacts.middle_name
, contacts.last_name
, a
The following query is generated by a PHP script:
select contacts.first_name, contacts.middle_name, contacts.last_name,
addresses.h_city, contacts.email1 from contacts, addresses,
contacts_addresses, trips, contacts_trips where trips.premium > 100 and
trips.premium < 201 and contacts.id=contac
