1 Reply Latest reply on Apr 7, 2009 11:48 AM by Günter Schenk

    ADDT not returning correct results

    xriokax

      Hello

       

      SELECT tblTraders.trader_company AS trader_ref, tblTrades.trade_name AS trade_ref, tblT2t.t2t_id
      FROM (tblT2t LEFT JOIN tblTraders ON tblT2t.trader_ref = tblTraders.trader_id) LEFT JOIN tblTrades ON tblT2t.trade_ref = tblTrades.trade_id
      WHERE {$NXTFilter_rstblT2t1}
      ORDER BY {$NXTSort_rstblT2t1}

      With reference to the above SQL statement generated while using dynamic list wizard, the SQL does not return the correct results.

       

      Sadly the SQL does not retrieve the field "trade_ref" and is blank when the "test" button is used.

       

      Anyone got any ideas?

       

      Cheers

       

      Paul

       

      Capture0006.JPG