[Solved] Selecting two columns from different tables in one result using MySQL [closed]


The SQL query would be

$sql = "SELECT t1.user_id FROM table1 AS t1 
                   JOIN table2 AS t2
                   ON t2.area_id = 3 
                   WHERE t1.cat_id = 11"

$this->query($sql);

See here for the documentation

2

solved Selecting two columns from different tables in one result using MySQL [closed]