Re: orm relation

2019-12-03 Thread bill dexter
> 'prn')) > > > Plz add more alias field as your sql command according to a sample above. > > Ps: check your question first(sql), then pass to communities. > > > > On Mon, Dec 2, 2019, 21:16 bill dexter <55dexte...@gmail.com> wrote: > >> thank you, but if

Re: orm relation

2019-12-02 Thread bill dexter
ups-with-q > > On Sun, Dec 1, 2019, 21:08 bill dexter <55dexte...@gmail.com> wrote: > >> ELECT a.matr >> ,[nom] >> ,[prn] >> ,cast([dat_nais] as date) as dat_nais >> , (YEAR(getdate()) - YEAR(dat_nais)) as age >> ,cast([dat_d

orm relation

2019-12-01 Thread bill dexter
ELECT a.matr ,[nom] ,[prn] ,cast([dat_nais] as date) as dat_nais , (YEAR(getdate()) - YEAR(dat_nais)) as age ,cast([dat_deces] as date) as dat_deces ,cast([dat_imm] as date) as dat_imm ,cast([dat_aj] as date) as dat_j ,[cod_position] ,YEAR(dat_imm) as