Forum Discussion

nick9one1's avatar
nick9one1
Icon for Helper III rankHelper III
2 years ago

Relating data without a primary key

I'm wondering if the way I relate data in tables that are related, but dont have a primary/foreign key is correct.  In the image below there are three SQL tables and a View (Submission_Scores). T...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

nick9one1 , Based on What I got. The fourth table should be joined with Site, Date (Create a date using month-year)