SQL Query: Combining Data for Comparison


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?