Top "Left-join" questions

doctrine 2 query builder and join tables

I'm trying to get all comments for each post in my home page return $this->createQueryBuilder('c') ->…

doctrine-orm left-join query-builder

MYSQL UNION DISTINCT

I have two selects that I'm currently running as a UNION successfully. (SELECT a.user_id, a.updatecontents AS city, …

mysql left-join union distinct

Left join or select from multiple table using comma (,)

I'm curious as to why we need to use LEFT JOIN since we can use commas to select multiple tables. …

sql mysql query-optimization left-join

Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON?

I'm experiencing a very confusing situation that makes me question all my understanding of joins in SQL Server. SELECT t1.…

sql sql-server tsql left-join

Return rows even if record does not exist LEFT OUTER JOIN

I have 2 tables below: Table_1 [Group No] [Test No] [Description] 123 1 [First Test] 123 2 [Second Test] 123 3 [Third Test] Table_2 [Sample No] [Test …

sql-server left-join

Join table twice - on two different columns of the same table

I have a very confusing database with a table that holds two values I need in a separate table. Here …

sql postgresql join foreign-keys left-join

Entity Framework include with left join is this possible?

I have the following tables ClassRoom (ClassID,ClassName) StudentClass (StudentID,ClassID) Student (StudentID,StudentName,Etc..) StudentDescription. (StudentDescriptionID,StudentID,StudentDescription) I …

c# entity-framework left-join

Counting number of joined rows in left join

I'm trying to write an aggregate query in SQL which returns the count of all records joined to a given …

sql oracle join count left-join

SQL LEFT JOIN return 0 rather than NULL

I want to join two tables, with the number of records for each type being counted. If there are no …

sql null left-join

Why is my left join not returning nulls?

In sql server 2008, I have the following query: select c.title as categorytitle, s.title as subcategorytitle, i.title as …

sql tsql sql-server-2008 left-join