Stack Overflow
Stack Overflow

Questions tagged [outer-join]

An outer join defines a relationship between two tables where all records from one or both tables are returned regardless of the existence of a matching key-field in the other table. A full outer join combines the results of both tables. A left or right join returns all the records from the first or second specified table, respectively. NULLS are filled in for matches on either side. A self-join compares a table to a copy of itself.

A full combines the results of both tables. A left or right returns all the records from the first or second specified table, respectively. NULLS are filled in for matches on either side. A compares a table to a copy of itself.

References

1671 questions
0
votes
2 answers

left outer join issue in mysql

I am try to get all the rows in parts_keywords not included in parts_questions. Unfortunately, I am getting all the rows of both tables. SELECT *FROM parts_keywords LEFT OUTER JOIN parts_questions ON parts_keywords.ID =…
earnest
  • 261
  • 2
  • 4
  • 9
0
votes
4 answers

Not sure what is the result of this right outer join

Right outer join is similar to a Union of a venn diagram right? I mean for A right outer Join B we should get all the rows of B and any matching rows in A. For some reason I am confused with the following: Assume table Orders: mysql> select * from…
Cratylus
  • 52,998
  • 69
  • 209
  • 339
0
votes
3 answers

Oracle Procedure - JOIN with Subquery

I need some help finishing this procedure. The problem is how to alias the different SELECTs so that I can match them on the RIGHT OUTER JOIN. The traditional AS doesn't work. Any ideas? PROCEDURE "GetProcessedEvents" ( "In_OccurredFrom"…
Linus
  • 87
  • 1
  • 8
0
votes
2 answers

LEFT OUTER JOIN needs improving due to poor performance

I have a table that has a Name column along with with 3 identifiers that refer to other entries within the same table. I a query that resolves those 3 identifiers into the actual names of the records they are referring to. So far I have only managed…
Phil Wright
  • 22,580
  • 14
  • 83
  • 137
0
votes
1 answer

SQL Compact Edition LEFT OUTER JOIN Average

I have a table with products and a table with ratings. I have the following query; SELECT products.name, ratings.rating FROM products LEFT OUTER JOIN ratings ON products.id = ratings.product_id; Returning me a nice list of rows…
Roel
  • 754
  • 3
  • 13
  • 30
0
votes
0 answers

Use a Linq statement to perform outer join

Starting with the collection below, what Linq statement do I need to return a results set that satisfies the test? private List _results; [SetUp] public void SetUp() { _results = new List { new {Id = 1, Names =…
Nick
  • 6,366
  • 5
  • 43
  • 62
0
votes
2 answers

Inner Join on many to many relationships on the two outer tables of the 5

I have the following tables: tPlans, tPlansProperties, tProperties, tEventsProperties, tEvents. For these tables there is a many to many relationship between tPlans and tProperties. There is also a many to many relationship between tEvents and…
Dave
  • 1,823
  • 2
  • 16
  • 26
0
votes
1 answer

MySQL count with multiple joins and group by

I can't seem to figure out the proper way to structure this query, and I know there's a way to do it with pure SQL and I would rather do it via a proper query than in my application logic. I have three tables: event_types, booking_types, and…
Austen Cameron
  • 342
  • 4
  • 14
0
votes
1 answer

sql server using outer join result into table format

I am setting a query to send the results via email and I am getting the result formatting incorrect. I want to select values from two tables where in table 1 a certain field is null and also add a related field from table 2 where table 1 id = table…
vbNewbie
  • 3,291
  • 15
  • 71
  • 155
0
votes
0 answers

Left outer join has different results in two different SQL Server versions

I have a table named Table1 with two integer fields: ID1 ID2 1 NULL 2 NULL 3 1 I have a view of this table named ViewOfTable1: SELECT ID1, ID2, 'Ok' AS Flag FROM Table1 WHERE ID2 IS NOT NULL I run the following query: SELECT Table1.ID,…
ssnkh
  • 109
  • 7
0
votes
2 answers

Creating a view and getting duplicate transactions

I have the following view: SELECT t.CompanyCode, t.FlatFileName, t.RecordNumber, t.Status, t.Branch, t.SalesMonthYear, t.SalesCashOrLimboCode, t.PageNumber, t.Driver, t.Truck, t.CommonProductCode, t.CashCharge,…
ErocM
  • 4,505
  • 24
  • 94
  • 161
0
votes
2 answers

How to use (left/right) outer join for this LINQ that join 3 entities?

Using MVC 3, EF4.1: Building a quiz screen, I am joining three entities: Steps, Questions, Responses Each Step can have many questions, each question can have one or no responses My issue is when I have no answers in my query, it returns steps with…
Chaka
  • 1,709
  • 11
  • 33
  • 58
0
votes
1 answer

Escape outer variable trap in two nested foreach with Dictionary

I have two objects that I initialize like this: var series = new Dictionary>() { {"0", new Dictionary() }, {"1", new Dictionary() }, {"2", new Dictionary() } } var…
CiccioMiami
  • 8,028
  • 32
  • 90
  • 151
0
votes
2 answers

Left outer join SQL Server

I'm confused as to why this is not working, I've used this type of syntax several times but this one as got me pulling my hair out. I have two tables; tableA regId name regStatus 1 George 1 2 Jenny 1 3 Penny 1 4 James 1 5 …
david-l
  • 623
  • 1
  • 9
  • 20
0
votes
1 answer

Right outer join in hql giving unexpected token for and condition

I am using hibernate 3.0. I am applying the right outer join. my query is List phaseCount1 = getHibernateTemplate().find("select count(phasesPlan.phaseid.id) as Phase from PhasePlan phasesPlan RIGHT JOIN " + "phasesPlan.phaseid…
Vaibhav Jain
  • 119
  • 3
  • 16
1 2 3
…
99 100