<?php $sql = $db->query("SELECT tab1.*, tab2.* FROM ". "tab1 left JOIN tab2 ON (tab1.clas = tab2.clas) ". "AND (tab1.name = tab2.name)"); ?>