Top "Join" questions

Difference between JOIN and INNER JOIN

Both these joins will give me the same results: SELECT * FROM table JOIN otherTable ON table.ID = otherTable.FK vs …

sql sql-server join inner-join

JOIN two SELECT statement results

Is it possible to join the results of 2 sql SELECT statements in one statement? I have a database of tasks …

sql select join group-by

INNER JOIN ON vs WHERE clause

For simplicity, assume all relevant fields are NOT NULL. You can do: SELECT table1.this, table2.that, table2.somethingelse FROM …

sql mysql join inner-join

What is the syntax for an inner join in LINQ to SQL?

I'm writing a LINQ to SQL statement, and I'm after the standard syntax for a normal inner join with an …

c# .net sql linq-to-sql join

Can I use CASE statement in a JOIN condition?

The following image is a part of Microsoft SQL Server 2008 R2 System Views. From the image we can see that …

sql sql-server join case

How to do 3 table JOIN in UPDATE query?

I asked a question and got this reply which helped. UPDATE TABLE_A a JOIN TABLE_B b ON a.…

mysql join

Join vs. sub-query

I am an old-school MySQL user and have always preferred JOIN over sub-query. But nowadays everyone uses sub-query, and I …

sql mysql subquery join

How can I join multiple SQL tables using the IDs?

I have 4 different tables that I want to join. The tables are structured with columns as follows: TableA - aID | …

mysql sql join

What is the difference between JOIN and UNION?

What is the difference between JOIN and UNION? Can I have an example?

sql database join union

SQL SELECT from multiple tables

How can I get all products from customers1 and customers2 include their customer names? customer1 table cid name1 1 john 2 joe …

sql select join left-join outer-join