Simple SQL??

furious5

I'm just trying to run a fairly complex SQL statement but it seems to be falling over early on, I've stared at the code for ages and still no progress.

SELECT * FROM villas, pricing WHERE villas.resort = 'pollenca' AND villas.resort = 'cala_dor'

If I run the statements seperately they both bring back results but if I run them together I get no results returned even though I know there are results.

Any ideas???

drag0n

well what your doing now is your querying for results that have both clauses

furious5

Maybe an OR may be a bit better then!

furious5

Just tried using the OR statement, however the search seems to be taking a long time. Is there a better way to do the search??

drag0n

ummm.... no iunless u reorganize ur db

furious5

Ok cheers, perhaps if I create an index that may speed things up

drag0n

definitely that woudl help a whole lot

superwormy

Think about what you're doing here and rethink your logic:

villas.resort = 'pollenca' AND villas.resort = 'cala_dor'

How can resort be equal to 'pollenca' and be equal to 'cala_dor' AT THE SAME TIME? It can be equal to one, or equal to the other, but how could it be equal to both at the same time?

drag0n

i think he already got that 🙂