3 Replies Latest reply: Jan 15, 2018 4:08 PM by Andy Weir RSS

    What will this do?

    MARK PERRONE

      Someone handed me this.  What I can see is.

       

      1. Ordered_mobile_base = all rows from mobile_base but only matches from mobile_latest_id.

       

      What does the where clause do for the last table?  I've never seen a syntax like even with SQL.

      Why even do the first table if you just want the lastrow?

       

      All referenced table and fields exist.

       

      [Ordered_mobile_base]:

      NOCONCATENATE

      LOAD

        *

      RESIDENT mobile_base;

      LEFT JOIN

      LOAD

        vin,

        mobile_lastrow

      RESIDENT

        [mobile_latest_id]

      ;

      DROP TABLE [mobile_base];

      Drop Table [mobile_latest_id];

       

      //find the latest records of inspex data

      [latest_mobile_base]:

      NOCONCATENATE

      LOAD

        *

      RESIDENT

        [Ordered_mobile_base]

      WHERE

        mobile_lastrow=mobile_recno

      ;

      Drop Table [Ordered_mobile_base];