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
4 answers

how to resolve StackOverFlowError?

My Inner and outer class file here:- package com.demo; public class Outer { int outer_x=100; void test(){ Inner inner =new Inner(); inner.display(); } public class Inner { void display(){ Outer ob=new Outer(); ob.test(); …
user2860053
0
votes
1 answer

Oracle - Join operation with table aliases

I have 3 Table A B and C. I want to firstly process Table A and B to create a table 'AB' then join the result of that to C. Here is what I have in mind: select C.number, C.class, AB.name from C, (select A.name, A.number from A FULL OUTER JOIN…
Rexroth
  • 109
  • 1
  • 12
0
votes
2 answers

How to update a Postgres table with a join statement?

I'd like to do something like this: update t1 set t1.column1 = 'changed' from left outer join t2 on t1.dataid = t2.dataid where t2.column2 != 'foo'; Basically, I need to check something in t2 when deciding which t1 records to update. How can I make…
BLuFeNiX
  • 2,496
  • 2
  • 20
  • 40
0
votes
1 answer

Cartesian join with multple outer joins to common root

I have the following schema. I can run two queries fairly simply select * from booking_model_assignment join booking_model on booking_model_assignment.booking_model_id = booking_model.id left outer join axis_channel_mappings on bmi_id =…
Jeremy French
  • 11,707
  • 6
  • 46
  • 71
0
votes
2 answers

msql insert data into table based on values in two other tables

I am using MySQL and have a table (documentShips) that I want to store connections / links between documents and users. The users table has columns including id, first_name and last_name etc... The documents table has columns including id and…
Jon Williams
  • 77
  • 10
0
votes
4 answers

Outer join in case statement

I have this below query: SELECT U.NAME , U.TYPE , U.REFERENCED_NAME , U.REFERENCED_TYPE, CASE WHEN U.REFERENCED_TYPE= 'TABLE' and A.TABLE_NAME= U.REFERENCED_NAME THEN 'TABLE EXISTS' WHEN U.REFERENCED_TYPE= 'PROCEDURE' and A.TABLE_NAME=…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
0
votes
2 answers

Access SQL - Get last available value

scenario: Table 1 (dates) 01/01/12 02/01/12 Table 2 (counts) 01/01/12 | Item 1 | 10 01/01/12 | Item 2 | 15 03/01/12 | Item 1 | 5 I have to join the two tables, not leaving gaps in dates: An OUTER JOIN did the trick. I want to have the last…
user2139366
  • 21
  • 2
0
votes
1 answer

ORA-00904 when using OUTER JOIN with 3 tables in clause

SELECT s.session_name semester FROM lsx.elsp_session s, lsx.elsp_course_offering co, its.ACCOUNT ac LEFT OUTER JOIN lsx.elsp_class_attendance ca on ca.course_id = CO.ID and ca.student_number = ac.id WHERE co.session_id =…
Andy Flanagan
  • 5
  • 1
  • 4
0
votes
2 answers

Inner join MYSQL query not working

I have a table structure with three tables: profiles, profile_subrubriek and rubrieken. I query the data with the following query: SELECT profiles.hoofdrubriek, profiles.plaats , profiles.bedrijfsnaam, profiles.gemeente, profiles.bedrijfsslogan ,…
user2704687
  • 185
  • 3
  • 11
0
votes
1 answer

two left outer joins query ambiguous column name

I am making a rails 4 app for a 'question and answer' forum. I have a model Micropost. I have a model QuestionAnswer which connects different microposts as questions and answers: Class Micropost < ActiveRecord::Base has_many question_answers,…
user2725109
  • 2,286
  • 4
  • 27
  • 46
0
votes
1 answer

SQL query with union and/or outer join needed

i could use some help. This is a real-life problem, not homework. I tried all kinds of outer join and union statements, but I am just making a mess. I have 3 tables: Table "item": id | name --------- 1 | 'Item 1' 2 | 'Item 2' Table…
Reto Höhener
  • 5,419
  • 4
  • 39
  • 79
0
votes
1 answer

OUTER JOIN not working as expected

So I know this has been done to death but I can't find the exact answer I need so am also happy to hear about alternatives on how to do this. IN SQL Server 2008R2 I Have a client ID, Year, Month & Revenue, AND I am doing a Full Outer Join because I…
user2807233
  • 1
  • 2
0
votes
0 answers

MSAccess with a WHERE Clause to only affect one of the LEFT JOINS

I have a 'busy' MSAccess SQL Query which I want to display a full set of results. In the main table 'JobsMain' a result is either a Maintenance Job or it is not. The following query (MSAccess Relationships:…
Paul Carruthers
  • 13
  • 3
0
votes
3 answers

Left Joins that link to multiple rows only returning one

I'm trying to join two table (call them table1 and table2) but only return 1 entry for each match. In table2, there is a column called 'current' that is either 'y', 'n', or 'null'. I have left joined the two tables and put a where clause to get me…
Nick
  • 3
  • 1
0
votes
2 answers

Incorrect key file for table error on outer join logic in MySQL

I have a lengthy MySQL query I'm attempting to use a FULL OUTER JOIN on, which does not exist in MySQL: select c.cat_id,c.cat_name as cat_name, c.cat_desc, c.cat_image, mi.filename, l.link_id, l.user_id, l.address,l.city, …
Zeno
  • 1,769
  • 7
  • 33
  • 61
1 2 3
…
99 100