I have a query that I build dynamically, here is an example:
select from (table1 as t1 left join table2 as t2 on t1.id = t2.id)
left join table3 as t3 on t1.id = t3.id where t1.id in ('221593',
'221591', 'CC3762', 'CC0059')
So I build the query in the order that I want it displayed. That i
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
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 com
