I have 2 or more tables that will frequently be used for JOINs in database VIEWs but they don't have any field in common so I'm considering adding the same generated id key to be inserted into a "join_id" field of 3 different tables to be joined later. I searched the internet regarding this type of topic but don't see much discussion so I'm cautious if it's good practice or not. Is it safe to proceed to do this kind of database operation?
Here's more details on what I want to accomplish
DEPT-A has their own table They will create a new row/record with flds1, flds2, flds3, innerjoin_id
DEPT-B has their own table with flds4, flds5, flds6, innerjoin_id
When DEPT-A creates a new row, a rule will be triggered to create a new row with same innerjoin_id in DEPT-B table also.
DEPT-B needs to see DEPT-A flds1, flds2, flds3 and be able to edit their respective flds4, flds5, flds6.
DEPT-A web input form will see flds1, flds2, flds3 (editable)
DEPT-B web input form will see flds1-readonly, flds2-readonly, flds3-readonly, flds4-editable, flds5-editable, flds6-editable
DEPT-A enters "apple", "banana", "cherry"
DEPT-B needs to see apple, banana, cherry and then in fld4-6 enter "applebanana", "bananacherry", "cherryapple"
DEPT-B is dependent on DEPT-A flds1-3
If DEPT-B cannot see "apple","banana","cherry" then they don't know what to input for flds4, flds5, flds6