Revision 60658
Added by Michele Artini about 3 years ago
| create_affiliations_tables.sql | ||
|---|---|---|
| 23 | 23 |
CREATE VIEW affiliations_view AS SELECT |
| 24 | 24 |
p.id as pid, |
| 25 | 25 |
TRIM(CONCAT(p.surname, ", ", p.name, " ", COALESCE(p.suffix, ''))) as pfullname, |
| 26 |
p.fullname as pname, //TODO DA TOGLIERE |
|
| 27 | 26 |
g.id as gid, |
| 28 | 27 |
g.name as gname, |
| 29 | 28 |
g.type as gtype, |
Also available in: Unified diff
minors