sermn_wiki:userpages:marta:esbos_116
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
sermn_wiki:userpages:marta:esbos_116 [2011/11/23 13:24] ferrannp [Esbós previ per la futura versió 1.1.6] |
sermn_wiki:userpages:marta:esbos_116 [2012/12/27 14:59] miquel [Grups de Recerca] |
||
|---|---|---|---|
| Line 11: | Line 11: | ||
| En qualsevol cas tot serà més senzill si establim un vincle directe entre l' | En qualsevol cas tot serà més senzill si establim un vincle directe entre l' | ||
| + | |||
| + | <note important> | ||
| + | La consulta següent no funciona com s' | ||
| + | </ | ||
| < | < | ||
| Line 27: | Line 31: | ||
| < | < | ||
| - | SELECT users.username, groups.longname, | + | SELECT users.name, groups.longname, |
| FROM users, usergroups, groups | FROM users, usergroups, groups | ||
| WHERE users.id = usergroups.userid | WHERE users.id = usergroups.userid | ||
| Line 37: | Line 41: | ||
| < | < | ||
| - | SELECT users.id, users.username, groups.longname, | + | SELECT users.id, users.name, groups.longname, |
| FROM users, usergroups, groups | FROM users, usergroups, groups | ||
| WHERE groups.id = usergroups.groupid | WHERE groups.id = usergroups.groupid | ||
| Line 88: | Line 92: | ||
| < | < | ||
| - | SELECT users.username, instruments.longname, | + | SELECT users.name, instruments.longname, |
| FROM users, permissions, | FROM users, permissions, | ||
| WHERE users.id = permissions.userid | WHERE users.id = permissions.userid | ||
sermn_wiki/userpages/marta/esbos_116.txt · Last modified: 2020/07/09 12:36 by miquel
