Rob Wultsch wrote:
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Aaron Fischer wrote:
Thanks Peter and Baron, these both worked well.
The "left join on" took .1919 seconds and the "left outer join as" took
.1780 seconds.
They are synonymous in MySQL. The only difference is 6 extra c
Aaron
>The "left join on" took .1919 seconds and the "left outer join as"
took .1780 seconds.
Caching :)
PB
-
Aaron Fischer wrote:
Thanks Peter and Baron, these both worked well.
The "left join on" took .1919 seconds and the "left outer join as"
took .1780 seconds.
=)
On Oct 26,
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> Aaron Fischer wrote:
> > Thanks Peter and Baron, these both worked well.
> >
> > The "left join on" took .1919 seconds and the "left outer join as" took
> > .1780 seconds.
>
> They are synonymous in MySQL. The only difference is 6 extra ch
Aaron Fischer wrote:
Thanks Peter and Baron, these both worked well.
The "left join on" took .1919 seconds and the "left outer join as" took
.1780 seconds.
They are synonymous in MySQL. The only difference is 6 extra characters
in the query text. The difference was probably due to caches.
Aaron Fischer wrote:
Greetings!
I have a problem that it seems would best be solved using subqueries.
However, I am working on a server that is running MySQL 3.23.58, so
subqueries are not available to me.
What I am trying to do:
I have two tables, each containing approximately 37,000 rec
Thanks Peter and Baron, these both worked well.
The "left join on" took .1919 seconds and the "left outer join as"
took .1780 seconds.
=)
On Oct 26, 2007, at 11:37 AM, Peter Brawley wrote:
Aaron
An exclusion join:
SELECT a.col
FROM a
LEFT JOIN b ON a.col=b.col
WHERE b.col IS NULL;
PB
Aaron
An exclusion join:
SELECT a.col
FROM a
LEFT JOIN b ON a.col=b.col
WHERE b.col IS NULL;
PB
Aaron Fischer wrote:
Greetings!
I have a problem that it seems would best be solved using subqueries.
However, I am working on a server that is running MySQL 3.23.58, so
subqueries are not avai
Aaron Fischer wrote:
Greetings!
I have a problem that it seems would best be solved using subqueries.
However, I am working on a server that is running MySQL 3.23.58, so
subqueries are not available to me.
What I am trying to do:
I have two tables, each containing approximately 37,000 recor
