Matthias Apsel: Sinn und Zweckmäßigkeit von Alias

Beitrag lesen

Hallo pl,

in Perl:

my $q = q(
  SELECT 
    a.name  as Lastname,
    a.vname as Firstname,
    k.name  as Konfession
  FROM
    address a
  JOIN 
    konfession k USING(id)
  WHERE
    k.name = "Konfessionslos"
  ORDER by
    a.name
);

in PHP:

$q = "  
  SELECT 
    a.name  as Lastname,
    a.vname as Firstname,
    k.name  as Konfession
  FROM
    address a
  LEFT JOIN
    konfession k USING(id)
  WHERE
    k.name = 'Konfessionslos'
  ORDER by
    a.name
";

Bis demnächst
Matthias

--
Pantoffeltierchen haben keine Hobbys.
¯\_(ツ)_/¯