Hello everybody,
I get following error:
When running following SQL Query:
I would appreciate if you could help me what I would need to change in my query. Thank you!
I get following error:
Code:
syntax error near "...achname, vorname)) *ERROR* Create table verwand...", expected end-of-file.
Code:
Create table Person ( Nachname varchar(20), vorname varchar(20), alter integer, Primary key (nachname, vorname)) Create table verwandtmit( P1NName varchar(20), P1VName varchar(20), P2NName varchar(20), P2VName varchar(20), Primary key(P1NName, P1VName, P2NName, P2VName), Foreign key(P1NName, P1VName) references Person, Foreign key(P2NName, P2VName) references Person); Insert into Person (Nachname, Vorname, Alter) values (Meyer, Hans, 17); Insert into Person (Nachname, Vorname, Alter) values (Meyer, Max, 18); Insert into verwandtMit {P1NName, P1VName, P2NName, P2VName} values (Meyer, Hans, meyer, max);
Comment