Problem on small project new to sql

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Problem on small project new to sql

Author

Topic

jfast
Starting Member

1 Post

Posted - 2012-09-18 : 07:10:17

Hi im new to al this sql and i keep geting errors (to many values) and dont know how to solve them. If someone could help i would be glad.

Here is the comand line i have writen to create 4tables, insert values into them:

create table gasilska_drustva
(id_drustva number(3), ime_drustva varchar(20), kraj_drustva varchar(16), URL_drustva varchar(32));

insert into gasilska_drustva values
(1, 'PGD_Cemsenik', 'Cemsenik', 'http://www.pgd-cemsenik.si/');

insert into gasilska_drustva values
(2, 'PGD_Padez', 'Padez', 'http://www.pgd-padez.si/');

insert into gasilska_drustva values
(3, 'PGD_Zagorje_mesto', 'Zagorje', 'http://www.pgd-zagorje.si/');

insert into gasilska_drustva values
(4, 'PGD_TET', 'Trbovlje', 'http://www.pgd-tetrbovlje.si/');

insert into gasilska_drustva values
(5, 'PGD_Kotredez', 'Kotredez', 'http://www.pgd-kotredez.si/');

desc gasilska_drustva;

select * from gasilska_drustva;

create table gasilska_vozila
(id_drustva number(3), tip_vozila varchar(5));

insert into gasilska_vozila values
(1, 'GVV1');

insert into gasilska_vozila values
(2, 'GVV1');

insert into gasilska_vozila values
(3, 'GVV1');

insert into gasilska_vozila values
(3, 'GVV2');

insert into gasilska_vozila values
(3, 'GVC1');

insert into gasilska_vozila values
(4, 'GVV1');

insert into gasilska_vozila values
(4, 'GVV1');

insert into gasilska_vozila values
(4, 'GVC1');

insert into gasilska_vozila values
(5, 'GVV1');

desc gasilska_vozila;

select * from gasilska_vozila;

create table nacin_delovanja_doma
(id_drustva number(3), nacin varchar(15));

insert into nacin_delovanja_doma values
(1, 'prostovoljno');

insert into nacin_delovanja_doma values
(2, 'prostovoljno');

insert into nacin_delovanja_doma values
(2, 'poklicno');

insert into nacin_delovanja_doma values
(4, 'poklicno');

insert into nacin_delovanja_doma values
(5, 'prostovoljno');

desc nacin_delovanja_doma;

select * from nacin_delovanja_doma;

create table gasilci
(id_gasilca number(3), ime_gasilca varchar(10), priimek_gasilca varchar(10), id_drustva number(3));

insert into gasilci values
(1, 'Janez', 'Novak', 1);

insert into gasilci values
(2, 'Tomaz', 'Rozina', 2);

insert into gasilci values
(3, 'Andraz', 'Vlaga', 3);

insert into gasilci values
(4, 'Boris', 'Klemencic', 3);

insert into gasilci values
(5, 'Danilo', 'Juvan', 3);

insert into gasilci values
(6, 'Joze', 'Kovac', 4);

insert into gasilci values
(7, 'Sandi', 'Volk', 4);

insert into gasilci values
(8, 'Franc', 'Klopcic', 4);

insert into gasilci values
(9, 'Stane', 'Novak', 5);

desc gasilci;

select * from gasilci;

select * from gasilci
where id_drustva = 1;

select * from gasilska_drustva,nacin_delovanja_doma
where gasilska_drustva.id_drustva = nacin_delovanja_doma.id_drustva
and nacin_delovanja_doma.nacin != 'poklicno';

spool off

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-09-18 : 07:38:17

hi jfast,

Which database you are using? (Oracle or SQL server or DB2??)

--
Chandu

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-18 : 10:54:07

i doubt you're using sql server as number is not valid datatype in t-sql

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources