1 CREATE OR REPLACE ALGORITHM
=MERGE VIEW fusionax_xorg_anciens
AS
3 u.user_id
, u.matricule_ax
, u.promo
,
4 n.display
AS display_name
, n.sort
AS sort_name
,
6 FROM `auth_user_md5`
AS u
7 INNER JOIN `profile_names_display`
AS n
ON ( n.user_id
= u.user_id
);
9 -- vim:set syntax=mysql: