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