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 records. I
want to
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
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
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 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
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.
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
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, 2007, at
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 characters
in the