我有一个首选项表,叫做"txp_prefs“。我希望在一行中返回多个首选项;我更喜欢这样做而不是简单的连接,因为我使用了一个可以处理单行的textpattern插件。FROM txp_prefs t2 WHERE t2.event="season" AND t2.name="season_end" (to get the season_end)
但是当我尝试将两者连接在一起时FROM txp_prefs t2 WHERE t2.event="season" AND t2.
我有以下代码:$sql= "SELECT `TABLE_1.ID`, `TABLE_2.ID`, `POTATO` FROM `TABLE_1.ID` LEFT JOIN `TABLE_2` ON `TABLE_1`.`ID` = `TABLE_2`.`ID_OF_OTHER_TABLE`;";foreach ($rows as $row){