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
 traditional join /6 entities- PLEASE URGENT!!!

Author  Topic 

whitepear
Starting Member

24 Posts

Posted - 2014-04-13 : 11:40:07
Hello!
Please, I am a very beginner and have to connect 6 entities.
Please, does anyone see what is wrong in this code, cause I am getting NO RESULT (no output)!!!

Many thanks!!!

BEGIN TRANSACTION;


DROP TABLE TOPIC;
DROP TABLE LECTURE;
DROP TABLE PRICE;
DROP TABLE COURSE;
DROP TABLE PUPIL;
DROP TABLE LP;

CREATE TABLE TOPIC(
TNAME TEXT PRIMARY KEY,
FK_CNAME
);
CREATE TABLE LECTURE(
LNAME TEXT PRIMARY KEY,
FK_TNAME TEXT,
FK_PPRICE INTEGER
);
CREATE TABLE PRICE(
PPRICE INTEGER PRIMARY KEY
);
CREATE TABLE COURSE(
CNAME TEXT PRIMARY KEY
);
CREATE TABLE PUPIL(
PNAME TEXT INTEGER PRIMARY KEY
);
CREATE TABLE LP(
LPNAME TEXT PRIMARY KEY,
FK_LNAME,
FK_PNAME TEXT
);
INSERT INTO PUPIL VALUES('Ana');
INSERT INTO PUPIL VALUES('Maja');
COMMIT;
INSERT INTO LP VALUES('LP1', 'L1', 'Ana');
INSERT INTO LP VALUES('LP2', 'L2', 'Ana');
INSERT INTO LP VALUES('LP3', 'L3', 'Ana');
INSERT INTO LP VALUES('LP4', 'L4', 'Ana');
INSERT INTO LP VALUES('LP5', 'L5', 'Ana');
INSERT INTO LP VALUES('LP6', 'L6', 'Ana');
INSERT INTO LP VALUES('LP7', 'L7', 'Ana');
INSERT INTO LP VALUES('LP8', 'L8', 'Ana');
INSERT INTO LP VALUES('LP9', 'L9', 'Ana');
INSERT INTO LP VALUES('LP10','L10', 'Ana');
INSERT INTO LP VALUES('LP11','L1', 'Maja');
INSERT INTO LP VALUES('LP12','L2', 'Maja');
COMMIT;
INSERT INTO TOPIC VALUES('PIANNO','MUSIC');
INSERT INTO TOPIC VALUES('VIOLA','MUSIC');
INSERT INTO TOPIC VALUES('BMW','CARS');
INSERT INTO TOPIC VALUES('AUDI','CARS');
INSERT INTO TOPIC VALUES('DOGS','ANIMALS');
INSERT INTO TOPIC VALUES('CATS','ANIMALS');
COMMIT;
INSERT INTO LECTURE VALUES('L1','PIANNO',10);
INSERT INTO LECTURE VALUES('L2','VIOLA',20);
INSERT INTO LECTURE VALUES('L3','BMW',30);
INSERT INTO LECTURE VALUES('L4','AUDI',40);
INSERT INTO LECTURE VALUES('L5','DOGS',10);
INSERT INTO LECTURE VALUES('L6','CATS',20);
INSERT INTO LECTURE VALUES('L7','PIANNO',30);
INSERT INTO LECTURE VALUES('L8','VIOLA',40);
INSERT INTO LECTURE VALUES('L9','BMW',10);
INSERT INTO LECTURE VALUES('L10','AUDI',20);
COMMIT;
INSERT INTO PRICE VALUES(10);
INSERT INTO PRICE VALUES(20);
INSERT INTO PRICE VALUES(30);
INSERT INTO PRICE VALUES(40);
COMMIT;
INSERT INTO COURSE VALUES('MUSIC');
INSERT INTO COURSE VALUES('CARS');
INSERT INTO COURSE VALUES('ANIMALS');
COMMIT;

SELECT * FROM COURSE,TOPIC,LECTURE,PRICE,LP,PUPIL WHERE COURSE.CNAME=TOPIC.FK_CNAME AND TOPIC.TNAME=LECTURE.FK_TNAME AND PRICE.PPRICE=LECTURE.FK_PPRICE AND PUPIL.PNAME=LP.FK_PNAME AND LP.FK_LNAME=LECTURE.LNAME;


visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-04-13 : 14:26:46
Are you using SQL Server? I see lot of syntax errors in the code based on T-SQL conventions.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -