Top "Join" questions

LINQ: combining join and group by

I have a query that combines a join and a group, but I have a problem. The query is like: …

c# linq linq-to-sql join group-by

Python: How exactly can you take a string, split it, reverse it and join it back together again?

How exactly can you take a string, split it, reverse it and join it back together again without the brackets, …

python string join split reverse

How to exclude rows that don't join with another table?

I have two tables, one has primary key other has it as a foreign key. I want to pull data …

sql join

SQL LEFT-JOIN on 2 fields for MySQL

I have a view A and a view B. In A I have a lot of information about some systems, …

mysql sql join left-join

MySQL select rows where left join is null

I have these MySQL tables: table1: id | writer 1 | Bob 2 | Marley 3 | Michael table2: user_one | user_two 1 | 2 And this query: SELECT …

mysql sql join left-join

LINQ Joining in C# with multiple conditions

I have a LINQ Joining statement in C# with multiple conditions. var possibleSegments = from epl in eventPotentialLegs join sd in …

c# linq join multiple-conditions

Multiple INNER JOIN SQL ACCESS

Syntax Error (missing Operator) in query expression 'tbl_employee.emp_id = tbl_netpay.emp_id INNER JOIN tbl_gross ON …

sql ms-access join inner-join

INNER JOIN same table

I am trying to get some rows from the same table. It's a user table: user has user_id and …

mysql sql join self-join

MySQL Join Where Not Exists

I have a MySQL query that joins two tables Voters Households They join on voters.household_id and household.id. …

mysql join not-exists

CakePHP find method with JOIN

Hi, I need to do the following query using the CakePHP find method: SELECT * FROM `messages` INNER JOIN users ON …

php sql cakephp join