Changeset 20894 in main


Ignore:
Timestamp:
06/28/20 10:31:38 (9 days ago)
Author:
Paul Leo
Message:

Montana birth query Left Join Pop to pick up unknown

File:
1 edited

Legend:

Unmodified
Added
Removed
  • adopters/mt/trunk/src/main/backend_qModules/birth23/MT_Percentage_data_frame.def

    r20072 r20894  
    119119                        create table rate as
    120120                        select tmp.*, pop.*
    121                         from tmp, pop
    122                         where
     121                        from tmp left join pop
     122                        on
    123123                        ?popcross1? tmp.%cross1%=pop.%popcross1%;
    124124                        ?popcross2? tmp.%cross2%=pop.%popcross2%; 
     
    135135                        create table rate as
    136136                        select tmp.*, pop.*
    137                         from tmp, pop
    138                         where tmp.%cross1%=pop.%popcross1% and
     137                        from tmp left join pop
     138                        on tmp.%cross1%=pop.%popcross1% and
    139139                        tmp.%cross2%=pop.%popcross2%;
    140140                quit;
Note: See TracChangeset for help on using the changeset viewer.