>This is the main reason why it's slow; The current MySQL can't yet
>optimize queries where columns are stored differently.
How 'different' do the tables have to be?
is customerid mediumint(9) different from customerid mediumint(8)?
or itemid varchar(13) different from itemid char(13)?
Tony
--
-----------------------------------------------------------------------------
Tony Bowden | tony@stripped http://www.blackstar.co.uk/
Black Star | The UK's Biggest Video & DVD store * Free Postage Worldwide
-----------------------------------------------------------------------------
