Changeset 19488


Ignore:
Timestamp:
Apr 4, 2019, 6:12:53 PM (2 weeks ago)
Author:
dorner
Message:
improved solution iwth joins
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/DataCheck/Sourcefile.sh

    r19209 r19488  
    254254   # add table
    255255   query=$query" "$maintable"Status"
    256    # add special join
     256   # add special joins
    257257   query=$query" "`getfromsetup $maintable "SpecialJoin"`
     258   if [ "$1" = "set" ]
     259   then
     260      query=$query" "`getfromsetup $maintable "SpecialJoinSet"`
     261   fi
    258262   # add join for step unless step is the same as maintable
    259263   if ! [ "$step" = "$maintable" ]
     
    275279         if [ "$1" = "set" ]
    276280         then
    277             query=$query" "`getfromsetup $otherstep "SpecialJoin2"`
     281            query=$query" "`getfromsetup $otherstep "SpecialJoinSet2"`
    278282            query=$query" LEFT JOIN "$otherstep"Status USING("`getfromsetup $otherstep "Primaries"`") "
    279283         fi
Note: See TracChangeset for help on using the changeset viewer.