> '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
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
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
3 matches
Mail list logo