INSERT INTO  envio VALUES ('0', '2009-02-14', 'Bafut');
INSERT INTO  envio VALUES ('1', '2009-02-27', 'Batanga');
INSERT INTO  envio VALUES ('2', '2009-03-29', 'Gawada');
INSERT INTO  envio VALUES ('3', '2009-04-06', 'Kiga');
INSERT INTO  envio VALUES ('4', '2009-08-23', 'Mahafali');

INSERT INTO  equipo VALUES ('0', '2009-3-14');
INSERT INTO  equipo VALUES ('1', '2009-3-28');

INSERT INTO  material VALUES ('2');
INSERT INTO  material VALUES ('3');
INSERT INTO  material VALUES ('4');

INSERT INTO producto VALUES ('2','Legumbres','100','Kg');
INSERT INTO producto VALUES ('3','Agua','1000','L');
INSERT INTO producto VALUES ('4','Gasolina','2000','L');

INSERT INTO sede VALUES ('123', 'Avenida Romualdo Galdós', 'Eibar', '945342165', NULL);
INSERT INTO sede VALUES ('456', 'Plaza Olmedo', 'Zamora', '987231256', NULL);

INSERT INTO persona VALUES ('21', 'Pello', 'Avenida Serrano', 'Pello_24@gmail.com', '123');
INSERT INTO persona VALUES ('32', 'Julián', 'Avenida Vitoria', 'Julito_24@gmail.com', '123');
INSERT INTO persona VALUES ('43', 'Juan', 'C/ El Manzano', 'Juanito_32@gmail.com', '456');
INSERT INTO persona VALUES ('54', 'PelloMari', 'C/ Uranga', 'PelloMari_29@gmail.com', '456');
INSERT INTO persona VALUES ('65', 'Adrián', 'C/ Lopetegui', 'Adri_24@gmail.com', '456');

UPDATE Sede
SET Director = '21'
WHERE Id = '123';

UPDATE Sede
SET Director = '32'
WHERE Id = '456';



INSERT INTO teléfonos VALUES ('21', '696827162');
INSERT INTO teléfonos VALUES ('21', '672516725');
INSERT INTO teléfonos VALUES ('32', '674019182');
INSERT INTO teléfonos VALUES ('43', '962718291');
INSERT INTO teléfonos VALUES ('54', '976516171');
INSERT INTO teléfonos VALUES ('54', '987261829');


INSERT INTO socio VALUES ('43', '1234567890', '1', '20');
INSERT INTO socio VALUES ('54', '1234567891', '12', '250');




INSERT INTO voluntario VALUES ('43');
INSERT INTO voluntario VALUES ('54');


INSERT INTO organiza VALUES ('123' , '0');
INSERT INTO organiza VALUES ('123' , '1');
INSERT INTO organiza VALUES ('123' , '2');
INSERT INTO organiza VALUES ('456' , '3');
INSERT INTO organiza VALUES ('456' , '4');



INSERT INTO sanitario VALUES ('43', 'ATS');
INSERT INTO sanitario VALUES ('54', 'enfermera');

INSERT INTO participa VALUES ('43', '0');
INSERT INTO participa VALUES ('54', '1');


----------------


SELECT DISTINCT e.Codigo, e.FechaPartida, e.Destino
FROM organiza AS o  JOIN envio AS e ON e.codigo=o.Envio

WHERE o.sede='123' AND e.codigo NOT IN (
	SELECT codigo
	FROM equipo)