SQL Query: Combining Data for Comparison

advertisements

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.

http://www.tutorialspoint.com/sql/sql-self-joins.htm

SQL join on multiple columns in same tables

[What is SELF JOIN and when would you use it?