I have a User that can have collection of users he likes... Another user can have collection of users he likes....
I am trying to implement multiple relations between records of the same model via self-joins (based on @Shtééf\'s answer). I have the following models
I\'m trying to provide reporting functionality on a typical restaurant type database. I describe the specifics of the problem below, but in a nutshell I need to be able retrieve aggregate data (sums a
I have a List<ClaimEvent> made up of this class: public class ClaimEvent { public ClaimEventType ClaimEventClaimEventType { get; set; }
I have a situation where I need to do a self join on a table in LINQ. The table consists of fields ItemsID, Title, SeriesTitle, and many other. An item can be either a series or members and I can tell
I am writing some queries with self-joins in SQL Server. When I have only one col开发者_开发问答umn in the SELECT clause, the query returns a certain number of rows. When I add another column, from th
I have inserted both category and sub-category in same table. id , name , mainCat , Here is the name of the category .If a user add a subcategory then i will add the parent cate开发者_JAVA技巧gory t
I have a Forum model, whose instances can have many nested forums: class Forum < ActiveRecord::Base
I\'m trying to update a table using a self join and aggregates. For example, a tabl开发者_如何学JAVAe has the following columns:
To promote bonding in my fraternity, I\'m trying to design a system where people can rate how well they know each other, then it will match up those who know each other least. This is what the table f