Is there a best practice how to join different tables?
I normally try to use left join with my main table, which creates only one list of records (see Capture1.JPG), as opposed to a whole bunch of table structures with links with each joined key (see Capture.JPG.)
I want to be able to export the raw database as it is, not with any outer joins, creating new records that are not part of the data base, just because they are part of a mapping table.
Yes, I would recommend you to consider it, you might find benefits doing so. Sometimes it gets really hard to do correct calculations on joined tables where you have one-to-many relationships.
