Thread: view oder join

$sql = "SELECT 
          wkz1.ART AS WKZ_ART,
          tb_ec_wed.BEMERK_WED,
          wkz1.STATUS_WKZ, 
          tb_ec_cab.STATUS_CAB, 
          tb_ec_pf.STATUS_PF, 
          tb_ec_wed.USER, 
          tb_ec_wed.DATUHR, 
          tb_ec_wed.ID as wedid,
          wkz1.BEZ_WKZ as bez_aktu_wkz,
          wkz2.BEZ_WKZ as bez_orig_wkz,
          wkz3.WKZ_COUNT as WKZ_COUNT,
          tb_ec_pf.SERNUM_PF,
          tb_ec_cab.SERNUM_CAB,
          tb_ec_zone.BEZ_Z,
          wkz1.ID AS wkzid,
          tb_ec_pf.ID AS pfid,
          tb_ec_cab.ID AS cabid,
          wkz1.BEZ_WKZ AS tt,
          tb_ec_hmi.ID AS hmiid,
          tb_ec_hmi.BEZ_HMI,
          tb_agid.ID as AGIDID,
          tb_agid.AGID
 
          FROM 
        tb_ec_wed 
          LEFT JOIN tb_ec_wkz as wkz1 ON ID_WKZ = wkz1.ID
          LEFT JOIN tb_ec_wkz as wkz2 ON ID_WKZ_ORIG = wkz2.ID
          LEFT JOIN tb_ec_wkz as wkz3 ON ID_WKZ = wkz3.ID              
          LEFT JOIN tb_ec_pf ON ID_PF = tb_ec_pf.ID 
          LEFT JOIN tb_ec_cab ON ID_CAB = tb_ec_cab.ID
          LEFT JOIN tb_ec_zone ON ID_ZONE = tb_ec_zone.ID
          LEFT JOIN tb_ec_hmi ON ID_HMI = tb_ec_hmi.ID
          LEFT JOIN tb_agid ON tb_agid.ID = tb_ec_wed.ID_AGID  
          WHERE LOCATION_WED = '$location_url'
          $gernot
          ORDER BY $sort $order";

 $gernot = "AND wedid = '$ID'";