Re: Select an array from one databank and compare it to one from another databank

[Frank Olschewski]

Hey Barry,

I wrote the tables on a paper and I think I understood it now. What is still troubling me is, in which order are they connected? It just seems random:
First, the teach_subj table connects with the teachers table, then the subjects table connects with the teach_subject table and then the subjects table connects with the request_id - I somehow don't sense any logical order there.
Why do the teachers and the subject table not simply connect to the teach_subject table, which then connects to the requests?
I will now start to rearrange my tables.