please, i have a database, in this database i have a table (FICHENAME), this elements have several criteria (Ex : core competence and condition of access and ..) each element for the criteria is represented by a table in this database.
i need to create a combination between the same table to compare FICHENAME1 with (FICHENAME1 and FICHENAME2 and .....FICHENAME N) if i have a common criteria i insert 1 in bit column.
in this image you have a FICHENAME table with the criteria i need to compare with the same
i need solution to representing this data or only create this combination (solution : SQL, SSIS, ..)
A self join is simply when you join a table with itself.
SQL join on multiple columns in same tables
[What is SELF JOIN and when would you use it?