recommend a way to optimise this?
The query is being cached - which is why it's quick the second time.
many examples of using joins in this way within these NGs.
> The query is being cached - which is why it's quick the second time.
as well. Any suggestions ?
What happens if you leave out the GROUP BY clause?
there may be more than one male holding the name John Smith :-).
column or a set of columns as being 'unique'.
Perhaps I should add that I'm more used to Oracle than to MySQL.
Interesting, the Js are all missing their closing quote.
them but this seems to take you in more like the right direction.
Wierd about that missing quote???
> them but this seems to take you in more like the right direction.
> Wierd about that missing quote???
names that were duplicated in the Smith family.
overlap those of country B.
want to be your customers also.
is essentially the same in Oracle and MySQL.
Yes, but how it is done in different databases is different.
Please give me your cell phone number.
What! You don't have a cell phone!
Sorry, we only do business with cell phone owners.
> Please give me your cell phone number.
> What! You don't have a cell phone!