Anton: 1 oder 2 Queries nötig?

Beitrag lesen

$sql="SELECT function, c.id, cf.email,
      CONCAT(c.phone_country, ' ', c.fax_city, ' ', c.fax_no, ' ', c.fax_ext) fax,
CONCAT(c.phone_country, ' ', c.phone_city, ' ', c.phone_no, ' ', c.phone_ext) phone,
LOWER(CONCAT(name_f, '_', name_l)) AS folder,
CONCAT(name_f, ' ', name_l) AS name
FROM contacts c, contacts_functions cf
WHERE (c.id = '".$id."') AND
      (c.id = cf.id) AND
      (cf.public = 'j')";
 */

$sql="SELECT function, id, email,
CONCAT(phone_country, ' ', fax_city, ' ', fax_no, ' ', fax_ext) AS fax,
CONCAT(phone_country, ' ', phone_city, ' ', phone_no, ' ', phone_ext) AS phone,
LOWER(CONCAT(name_f, '_', name_l)) AS folder,
CONCAT(name_f, ' ', name_l) AS name
FROM contacts JOIN contacts_functions
USING id
WHERE (public = 'j') AND (id = '".$id."')";

Warum gibt der untere QUERY einen Syntax Fehler ? Die beiden Queries sind meiner Meinung nach identisch. :(