Базы данных

INSERT INTO TblStudent

     VALUES ('8','Бердыев','Курбан','Бердыевич','муж',

     'узбек','01.04.1990','Деребаса 17-55',

     '-','Электроэнергетика','120000');

INSERT INTO TblStudent

     VALUES ('9','Жандарбеков','Тимур','','муж',

     'казах','15.01.1989','Кутузова 204-654',

'+7-7182-320032','Информационные системы','160000');

INSERT INTO TblStudent

     VALUES ('10','Дитковските','Агния','Олеговна','жен',

     'литовка','11.05.1988','Бекхожина 11-4',

     '+7-701-7412580','Архитектура и дизайн','180000');  

     Результат запроса:

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('1','5','180000','01.10.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('2','1','30000','28.09.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('3','1','50000','27.10.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('4','1','40000','15.11.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('5','2','10000','15.09.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('6','2','40000','02.10.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('7','2','5000','13.11.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('8','3','150000','10.01.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('9','4','40000','28.01.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('10','4','40000','30.10.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('11','6','15000','09.09.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('12','8','10000','09.09.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)

      VALUES('13','8','40000','10.10.2011');

INSERT INTO TblSPay (PayID, StudID, PaySumm, PayDate)