Join tables - how to join these tables help

1

can anyone help me here - how do I join these two tables? I have tried but Iā€™m stuck.
Thank you so much :pray:

drop database if exists quiz; 
create database quiz; 
USE quiz; 
CREATE TABLE spm (ID int  auto_increment, Tekst varchar (500), primary key(ID));
CREATE TABLE svar (ID int  auto_increment, Tekst varchar (100), korrekt boolean, spmID int, primary key(ID), FOREIGN KEY(spmID) REFERENCES spm(ID));
INSERT INTO spm(Tekst) VALUES ('Hva er 7 % 3 i SQL?');
INSERT INTO spm(tekst) values ('Hva er 7/3 ?');
INSERT INTO svar(tekst, korrekt, spmid) VALUES('4', false,1); 
INSERT INTO svar(tekst, korrekt, spmid) VALUES('1', true,1);
INSERT INTO svar(tekst, korrekt, spmid) VALUES('3', false,1);
INSERT INTO svar(tekst, korrekt, spmid) VALUES('2', false,1);
INSERT INTO svar(tekst, korrekt, spmid) VALUES('1,5', false,2);
INSERT INTO svar(tekst, korrekt, spmid) VALUES('2,3', true,2);
INSERT INTO svar(tekst, korrekt, spmid) VALUES('1,7', false,2);
2

SQL - Using Joins

3
4

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.