your create table statements won't work.

so fix that, then post what you have come up with so far