[q][i]Originally posted by: [b][b]BKBK[/b][/b][/i]
I am ignoring cachedWithin because it seems to be redundant in your code. I am
also assuming that myID is a key, and so is unique. Then one can combine Query
One and Query Two thus
<cfquery name="uniqueQuery" dbtype="query">
FROM favorite_sites, notes_get
I know this method, but what i'm really trying to do is filter the results
too. Thats why i was trying WHERE db_new.notes.myID = 2 OR
db_new.favorite_sites.myID = 2, but that didnt work, since its actually joining
the queries instead of filtering it.
sorry, i couldnt find this thread.
Let me make couple of things clear.
-The column myID is not unique
-unique column is "id"
-since myID is not unique, it contains multiple values that i'm trying to
filter. In this case, "2", so all the results containing 2 should come up
instead of repeating it again and again through join query.
Why i'm trying to do this?:
Well, i have pages that are reaching around 13-15 queries. That is one page
only, someone suggested that i should combine the queries as much as i can.
But, for some reason i cant get it to work. So, if i can probably reduce it to
6-7 queries, it will reduce the execution time.