All Questions

92
votes
4answers
135421 views

Select rows which are not present in other table

I've got two postgresql tables: table name column names ----------- ------------------------ login_log ip | etc. ip_location ip | location | hostname | etc. I want to get every IP ...
1091
votes
15answers
1088245 views

LEFT JOIN vs. LEFT OUTER JOIN in SQL Server

What is the difference between LEFT JOIN and LEFT OUTER JOIN?
16
votes
3answers
8120 views

Two SQL LEFT JOINS produce incorrect result

I have 3 tables: users(id, account_balance) grocery(user_id, date, amount_paid) fishmarket(user_id, date, amount_paid) Both fishmarket and grocery tables may have multiple occurrences for the same ...
148
votes
6answers
93007 views

Linq to Sql: Multiple left outer joins

I'm having some trouble figuring out how to use more than one left outer join using LINQ to SQL. I understand how to use one left outer join. I'm using VB.NET. Below is my SQL syntax. T-SQL SELEC...
196
votes
9answers
249496 views

Difference between left join and right join in SQL Server

I know about joins in SQL Server. For example. there is two tables Table1, Table2. There table structure are following. create table Table1 (id int, Name varchar (10)) create table Table2 (id int...
55
votes
3answers
65110 views

Can I use mysql JOIN without ON condition?

I could not learn how to use JOIN well. I was always using server side code for such objectives. Is it possible to write join query without ON? Basically how do these joins differ LEFT JOIN, RIGHT JOI...
140
votes
3answers
84044 views

Deleting rows with MySQL LEFT JOIN

I have two tables, one for job deadlines, one for describe a job. Each job can take a status and some statuses means the jobs' deadlines must be deleted from the other table. I can easily SELECT the ...
53
votes
4answers
78394 views

Entity framework left join

How do I change this query so it returns all u.usergroups? from u in usergroups from p in u.UsergroupPrices select new UsergroupPricesList { UsergroupID = u.UsergroupID, UsergroupName = u.UsergroupNa...
101
votes
8answers
151853 views

LINQ to SQL: Multiple joins ON multiple Columns. Is this possible?

Given: A table named TABLE_1 with the following columns: ID ColumnA ColumnB ColumnC I have SQL query where TABLE_1 joins on itself twice based off of ColumnA, ColumnB, ColumnC. The query might lo...
41
votes
6answers
103133 views

LINQ Inner-Join vs Left-Join

Using extension syntax I'm trying to create a left-join using LINQ on two lists that I have. The following is from the Microsoft help but I've modified it to show that the pets list has no elements. W...

Previous Next