Commit | Line | Data |
---|---|---|
29459c49 SJ |
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, | |
4 | u.nom, u.prenom | |
5 | FROM auth_user_md5 AS u | |
6 | INNER JOIN profile_names_display AS n ON (n.user_id = u.user_id); | |
424fb311 SJ |
7 | |
8 | -- vim:set syntax=mysql: |