Best Practice - Database design for 'conditional join'
5002
How to model an entity type that can have different sets of attributes?
55290
join syntax / style performance consideration
44786
Primary key for link/junction table with time-dependent data
83110
JOIN versus EXISTS performance
126514
Does anyone use Right Outer Joins?
85789
Not using foreign key constraints in real practice. Is it OK?
123947
JOINs with conditon in HQL query?
85172
Lookup Tables Best Practices: DB Tables... or Enumerations
22025
Which is better for long term database scalability: adding columns or having key/value store
124005
How to query records having at least one valid child record?
110786
T-SQL: Selecting rows to delete via joins
36725
MySQL - alternatives to nested subqueries when limiting aggregate data in a correlated subquery
73561
Oracle Joins - Comparison between conventional syntax VS ANSI Syntax
51863
Logical Conditional Truth Table Rationale
138284
Are individual queries faster than joins?
148559
Using the correct, or preferable, not equal operator in MySQL
104243
Using ISNULL vs using COALESCE for checking a specific condition?