title: How can I select distinct column based on max datetime (another column) also joining two tables in MySQL?
body: <p>I've read many somewhat similar questions here and tried everything I can think of, without success.  I think I've found the question based on a single table, or without the need for getting a distinct column, but not my situation exactly.</p>
  
  <p>I want to get distinct ticker_symbol and corresponding ticker_name and latest ticker_quote based on these tables:</p>
  
  <pre><code>CREATE TABLE `tickers` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `ticker_symbol` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
    `ticker_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
  
  
  
  CREATE TABLE `ticker_quotes` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `ticker_symbol` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
    `ticker_quote` float(8,2) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
  </code></pre>