I've got a unusual question.
The human resources needs to export an old DB to a new one.
And the guys managing the new DB wants one csv file with every dataset existing. I did a Relational database and now i find it difficult to write the select statement.
I did this:
SELECT * FROM teilnehmer, personen, seminare, termine, kategorien, haeuser WHERE teilnehmer.sid = seminare.sid AND teilnehmer.pid = personen.pid AND termine.sid = seminare.sid AND seminare.katid = kategorien.katid AND personen.hausid = haeuser.hausid ORDER BY personen.pid
but i only get ~1500 entrys. I know thats to little, because when i look for a Name and all the workshops he/she did, i get much more than what is in this export.
I don't need the answer i would appreciate if someone could give me a little hint in how to get this done. Till yet i had only like one join for the data i'd needed to display but this confuses me.