Revision 61881
Added by Michele Artini over 2 years ago
create_affiliations_tables.sql | ||
---|---|---|
29 | 29 |
a.year as year |
30 | 30 |
FROM |
31 | 31 |
persons p |
32 |
LEFT OUTER JOIN affiliations a ON (p.id = a.pid) |
|
33 |
LEFT OUTER JOIN groups g ON (a.gid = g.id); |
|
32 |
JOIN affiliations a ON (p.id = a.pid) |
|
33 |
JOIN groups g ON (a.gid = g.id); |
Also available in: Unified diff
fixed a NPE