A table can be joined to itself and this is called a self-join.
I have a User that can have collection of users he likes... Another user can have collection of users he …
entity-framework ef-code-first entity-framework-4.1 self-join self-referenceCould anyone advice on how do I improve the performance of the following query. Note, the problem seems to be …
sql sql-server sql-server-2008 self-join sqlperformanceI have an existing InnoDB table which already has foreign keys pointing to different tables. But when I try to …
mysql foreign-keys innodb self-join phpmyadminI'm trying to implement a social networking style friendship model and I didnt have much much luck trying to figure …
ruby-on-rails activerecord social-networking self-joinI would like to create a structure of Users having many friends, also of class User: class User < ActiveRecord::…
ruby-on-rails self-joinPossible Duplicate: combinations (not permutations) from cross join in sql I've currently got a table with the following records: A1 …
sql join self-joinI have a table that is set up so that one column (attribute) contains information like first name, last name, …
sql sql-server inner-join outer-join self-joinI have an ActiveRecord called Name which contains names in various Languages. class Name < ActiveRecord::Base belongs_to :language …
ruby-on-rails activerecord mysql self-joinIf I have a table that I'd like to cross join to itself, how can I remove the duplicate rows? …
sql self-join cross-join