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