Welcome to the Treehouse Community
Looking to learn something new?
Why does this not work as question 3??? Of the database foundations questions.
I have checked it and checked it and I cant find out why it is not working?
ALTER TABLE t_movies ADD COLUMN fk_genre_id INTEGER NULL ADD CONSTRAINT FOREIGN KEY(fk_genre_id) REFERENCES t_genres(pk_id);
Ken AlgerTreehouse Teacher
It looks like you are missing a comma between
INTEGER NULL and
ADD. Try that and post back with your results.
Thanks Ken, One comma was the problem. Many thanks.