Top "Join" questions

LINQ Join with Multiple Conditions in On Clause

I'm trying to implement a query in LINQ that uses a left outer join with multiple conditions in the ON …

linq join

MySQL: Quick breakdown of the types of joins

I would like a quick breakdown of the types of MySQL joins. I know of these, the rest I am …

mysql join

how to use a like with a join in sql?

I have 2 tables, say table A and table B and I want to perform a join, but the matching condition …

mysql sql join sql-like

How to use the COLLATE in a JOIN in SQL Server?

I´m trying to join two tables but I get this error: Msg 468, Level 16, State 9, Line 8 Cannot resolve the collation …

sql-server join collate

Join between tables in two different databases?

In MySQL, I have two different databases -- let's call them A and B. Is it possible to perform a …

mysql sql join

SQL Left Join first match only

I have a query against a large number of big tables (rows and columns) with a number of joins, however …

sql sql-server tsql join greatest-n-per-group

How to execute my SQL query in CodeIgniter

I have a problem with my query and I need to join two tables from different databases now my problem …

php sql codeigniter join multiple-databases

A method to reverse effect of java String.split()?

I am looking for a method to combine an array of strings into a delimited String. An opposite to split(). …

java string join split

MySQL JOIN with LIMIT 1 on joined table

I want to join two tables, but only get 1 record of table2 per record on table1 For example: SELECT c.…

mysql join limit

Java: function for arrays like PHP's join()?

I want to join a String[] with a glue string. Is there a function for this?

java php arrays join