SELECT france.dallay, france.designationcourt, france.valeurfaciale, france.couleurs, manques.neuf, manques.nac, manques.nsg, manques.oblitere, manques.surlettre
FROM themesassocies
RIGHT JOIN (manques RIGHT JOIN france ON france.dallay= manques.dallay and manques.no_adherent = #session.NoMembre#) ON themesassocies.dallay= france.dallay
Where left(france.dallay, 1) < 'A'
and themesassocies.theme=#Theme#
and (france.designation like '%#Motcle#%' or france.designationcourt like '%#Motcle#%' or france.dallay like '%#Motcle#%'
or france.valeurfaciale like '%#Motcle#%' or france.couleurs like '%#Motcle#%')
Order by france.ordre
Update manques set neuf=#LNSC#, nac=#LNAC#, nsg=#LNSG#, oblitere=#LOblitere#, surlettre=#LSurlettre#
Where no_adherent=#Session.NoMembre# and dallay='#qTimbres2.dallay#'
Insert into manques (no_adherent, dallay, neuf, nac, nsg, oblitere, surlettre)
VALUES (#Session.NoMembre#, '#qTimbres2.dallay#', #LNSC#, #LNAC#, #LNSG#, #LOblitere#, #LSurlettre#)
Delete from manques where dallay='#Dallay#' and no_adherent = #session.NoMembre#
Philatélix
SELECT * FROM profils where nochrono=#Session.NoMembre#
SELECT france.dallay, france.designationcourt, france.valeurfaciale, france.couleurs, manques.neuf,manques.nac,manques.nsg, manques.oblitere, manques.surlettre ,
cotations2001.neuf as cot_nsc, cotations2001.neufaveccharniere as cot_nac, cotations2001.nsg as cot_nsg, cotations2001.oblitere as cot_obli, cotations2001.lettre as cot_surl
FROM cotations2001, themesassocies
RIGHT JOIN (manques RIGHT JOIN france ON france.dallay= manques.dallay and manques.no_adherent = #session.NoMembre#) ON themesassocies.dallay= france.dallay
Where cotations2001.dallay=france.dallay and themesassocies.theme=#Theme#
and (france.designation like '%#Motcle#%' or france.designationcourt like '%#Motcle#%' or france.dallay like '%#Motcle#%'
or france.valeurfaciale like '%#Motcle#%' or france.couleurs like '%#Motcle#%')
Order by france.ordre