19 lines
483 B
Plaintext
19 lines
483 B
Plaintext
|
|
|||
|
|
-- Taulut
|
|||
|
|
|
|||
|
|
SELECT * FROM members;
|
|||
|
|
|
|||
|
|
SELECT * FROM positions;
|
|||
|
|
|
|||
|
|
SELECT * FROM sigs;
|
|||
|
|
|
|||
|
|
-- Kaikkien tekij<69>iden kaikki projektit
|
|||
|
|
|
|||
|
|
SELECT members.name,sigs.name FROM members, positions, sigs WHERE members.id = positions.person AND sigs.id = positions.sig ORDER BY members.name, sigs.name;
|
|||
|
|
|
|||
|
|
-- Kaikkien projektien kaikki tekij<69>t
|
|||
|
|
|
|||
|
|
SELECT sigs.name,members.name FROM members, positions, sigs WHERE members.id = positions.person AND sigs.id = positions.sig ORDER BY sigs.name, members.name;
|
|||
|
|
|
|||
|
|
|