SQL

how do we make a foreign key? how would we create a statement that queries both tables together?

/*assignment 7*/

CREATE DATABASE JojoBizzareAdventure;/*created a db called JojoBizzareAdventure*/

CREATE TABLE tbl_members( /*create table tbl_members*/

members_id INT PRIMARY KEY NOT NULL IDENTITY(12,2),/*members id starting at 12 going up by 2*/

members_firstname VARCHAR(50) NOT NULL, /*variable members_firstname*/

members_lastname VARCHAR(50) NOT NULL,/*variable members_lastname*/

members_age VARCHAR(50) NOT NULL,/*variable members_age*/

);

INSERT INTO tbl_members/*insert into table tbl_members*/

(members_firstname, members_lastname, members_age)/*order of variables*/

VALUES/*our values going into the variables ordered*/

('BRUNO','BUCCIARATI','20'),

('GIORNO','GIOVANNA','15'),

('GUIDO','MISTA','18'),

('LEONE','ABBACCHIO','21'),

('NARACIA','GHIRGA','17')

;

SELECT * FROM tbl_members;/*we display the contents in the table tbl_members*/

CREATE TABLE tbl_stands(/*creates a table tbl_stands*/

stand_id INT PRIMARY KEY NOT NULL IDENTITY(11,2),/*stands pk starting at 11 going up by 2*/

tbl_membersID VARCHAR(50) NOT NULL REFERENCES tbl_members(members_id),/*stand name varible, stands are embodiments of the soul*/

stand_alignments VARCHAR(50) NOT NULL/*the character alignments*/

);

INSERT INTO tbl_stands /*inserts content into our table tbl_stands*/

(stand_name,stand_alignments)/*order of variables*/

VALUES/*values going in ordered*/

('STICKY FINGERS','CHAOTIC GOOD'),

('GOLDEN EXPERIENCE','NEUTRAL GOOD'),

('SIX PISTOLS','CHAOTIC GOOD'),

('MOODY JAZZ','CHAOTIC NEUTRAL'),

('AEROSMITH','CHAOTIC GOOD')

;