ExpertRefresh

Using syntax

Which is correct







SELECT * FROM keyword JOIN keyword_log USING (page_id)

CREATE TABLE `keyword` ( `page_id` int(11) unsigned NOT NULL, `keyword` varchar(100) NOT NULL, `total` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`page_id`, `keyword`) ) CREATE TABLE `keyword_log` ( `page_id` int(11) unsigned NOT NULL, `keyword` varchar(100) NOT NULL, `ip` varchar(15) NOT NULL, UNIQUE KEY `page_id` (`page_id`,`keyword`) )