[Antivirus]

Thanks, for dma table, my source is as follows:

  `dmacode` int(10) unsigned NOT NULL auto_increment,
  `zipcode` int(5) unsigned zerofill NOT NULL default '00000',
  `rank` tinyint(2) unsigned zerofill NOT NULL default '00',
  `dmaname_clean` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`dmacode`)

for erc_venue table my source is:

  `venueid` int(6) unsigned NOT NULL auto_increment,
  `venuetitle` varchar(30) NOT NULL default '',
  `venueaddy` varchar(50) default NULL,
  `venuecitystate` varchar(50) default NULL,
  `venuezipcode` int(5) unsigned zerofill NOT NULL default '00000',
  `venuecountry` varchar(20) default 'USA',
  `venueurl` varchar(80) default NULL,
  `venuephone` varchar(12) default NULL,
  PRIMARY KEY  (`venueid`)

and the explain thingie is as follows:

SELECT erc_venue.*, dma.* 
FROM erc_venue
LEFT JOIN dma ON dma.zipcode = erc_venue.venuezipcode

ORDER BY erc_venue.venuetitle
LIMIT 0, 12
id select_type table type possible_keys key key_len ref rows Extra 
1 SIMPLE erc_venue ALL         98 Using temporary; Using filesort 
1 SIMPLE dma ALL         45534   

Time Before: 0.27991 seconds
Time After: 7.76009 seconds
Time Taken: 7.48018 seconds

Thanks!