SQL Query: combining data for the comparaison

Question

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, ..)

Answer 1

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?

Answer 2

If your table has a single column & you need to make combinations of it's element multiple times, then i'd suggest you query same table twice with no joins. In hat scenario you will get combination of elements with all possibilities.

SELECT S1.FICHENAME, S2.FICHENAME FROM your_table S1, your_table S2 ORDER BY S1.FICHENAME, S2.FICHENAME

Answer 3

thank you for your answer, i can use Cross join to create a combination :D

http://www.sqlguides.com/sql_cross_join.php

Answer 4

Simply use SelfJOin

Eg.

SLEECT a.FetchName1

FROM table a inner join table b On a.FetchName1=b.FetchName2 INNER JOIN Table c on a.Id=c.Id