strSQL = "SELECT " _
& "P.SPEC_PRATIC, " _
& "RS.NOM_PERSONNE, " _
& "P.CATEG_PRATIC, " _
& "RS.ADRESSE, " _
& "RS.VILLE, " _
& "RS.CODE_POSTALE " _
& "FROM " _
& "(SELECT DR.NO_PATRICIEN " _
& "FROM " & Session("owner" ) & ".DR_CONV_CCSS D," &
Session ("owner" ) & ".PRATICIENS P " _
& "WHERE P.NO_PRATICIEN = D.NO_PRATICIEN AND
D.FIN_CONV_CCS = '0' AND D.FIN_CONV_CCS > '20030705') C " _
& "INNER JOIN " _
& "(SELECT RS.MATRICULE " _
& "FROM " & Session("owner" ) & ".RACINE_SAL RS " _
& "WHERE RS.CO_RESID = '01' OR RS.CO_RESID = '06' OR
RS.CO_RESID = '22' " _
& "OR RS.CO_RESID = '32' OR RS.CO_RESID = '42' OR RS.CO_RESID
= '52') R " _
& "ON " _
& "C.NO_PRATICIEN = RS.MATRICULE; " _
& "WHERE " _
& "R.NOM_PERSONNE LIKE '" & Request.Form("nom" ) & "%' AND " _
& "C.SPEC_PRATIC = 'CV' " _
& "GROUP BY R.NOM_PERSONNE;"
|
