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

Inner, outer or full join on three tables in MySQL database on linux with apache

I want to have some help creating my query to get information from three different tables sharing information in common. My first table is: auctions id title description user_id(who posted it) My second table is: bids id user_id bid auction_id…
Justin
  • 81
  • 1
  • 2
  • 11
0
votes
3 answers

I can't wrap my head around joins

So, alright, I have a few tables. My current query runs against a "historical" table. I want to do a join of some kind to get the most recent status from my Current table. These tables share a like column, called "ID" Here's the…
user2249610
  • 5
  • 2
0
votes
4 answers

Using MySQL join to show unrelated records

I have a table of machines, and a table representing the reachability if these machines across time. machines id name 1 machine1 2 machine2 3 machine3 4 machine4 machines_reachability machine_id is_reachable time 1 …
Muhammad Gelbana
  • 3,890
  • 3
  • 43
  • 81
0
votes
1 answer

please help me in writing my sql query for this

table 1 : - name | location | Area | Region | Country ----------------------------------------- abc 8 6 9 12 table 2 : - lid | lname | aid | rid | cid def 8 6 9 12 table 3 : - aid | aname | rid | cid 6 …
Mohit
  • 1,204
  • 2
  • 13
  • 19
0
votes
1 answer

SQL Query correct way of doing a right outer join?

Having the following query as example: SELECT t1.itemid, t2.yearcreated FROM (SELECT '100051' AS 'itemid', '2012' AS yearcreated UNION SELECT '100051' AS 'itemid', '2013' AS yearcreated …
VSP
  • 2,367
  • 8
  • 38
  • 59
0
votes
0 answers

Outer Join Returns Multiple Rows

I am joining APPS.PER_JOBS on PER_ALL_ASSIGNMENTS_F, looking to get current row - but I get multiple rows unless I add REQUEST_ID to the join. However, when I do this - though it supresses the mulitple rows - it also causes the substring I use to…
smarca
  • 1
  • 1
0
votes
1 answer

how to fetch all row from one table and select row from other table based on first table?

i have a table one table message and other table is image . i want to fetch the data from image for the selected row from the message ( idea is that i want to display the images of sender that are stored in other table "IMAGE" and message are stored…
Kapil Dev
  • 11
  • 1
  • 8
0
votes
1 answer

SQL left outer joins

So I have one table which has employee number (empno), name(ename) and manager number(mgr). The question: List the names of all employees along with the name of their manager and the name of their manager's manager, with a blank at any left if a…
Ben Chapman
  • 25
  • 2
0
votes
1 answer

Django - outer join 2 querysets into 1 queryset without raw sql

Is there an option to create a queryset that outer joins 2 querysets without raw sql? I have one queryset that hits 1 table - queryset1 = Model1.objects.all() I have another queryset that hits the same table and does some aggregation - queryset2 =…
ge7600
  • 401
  • 3
  • 8
0
votes
3 answers

Using SELECT part in OUTER JOIN

This is my SQL-query: SELECT b.MaakArtikel, b.Bewerking, [pp].dbo.WORKINGDAYADD('2013-06-27 00:00:00.000',0-b.Startdag_backwards) AS Startdatum, i.Class_06 AS Afdeling, b.Minuten*10+ISNULL(br.Tijd,0) AS Minuten, …
Jovano
  • 291
  • 1
  • 5
  • 13
0
votes
1 answer

LEFT OUTER JOIN with a WHERE clause on the first table

I want to SELECT a some rows from a table, but these rows must satisfy a condition like column = value. Here's my SELECT statement: $query = "SELECT t1.title, t1.introtext, t2.jr_street, t2.jr_city, t2.jr_state, t2.jr_postalcode, t2.jr_country,…
JetPro
  • 1,044
  • 3
  • 23
  • 43
0
votes
1 answer

Join two Mysql tables by unique keywords and by adding total in column

I am trying to get daily totals for each location into another table. Here is the structure: reports_location_temp: Table_Name: Date: Total_Count: London 2013-05-26 10:49:53 …
Mannie Singh
  • 119
  • 3
  • 17
0
votes
1 answer

left and right joins in sql

I am trying to join three tables in SQL. I am using the following query but it is not working select * from char_level as c1 right join (SELECT distinct character_id as fid, target_character_dbid as tid FROM house where reason='set_house_access'…
ayush singhal
  • 1,879
  • 2
  • 18
  • 33
0
votes
1 answer

How to eliminate duplicate rows joining on tables across databases?

I have been working on this script for a while and have reached a dead end. The script works but unfortunately produces duplicates. My script joins two different tables across databases on a state_issue_teacher_id key and then produces the output.…
Tone
  • 765
  • 10
  • 24
  • 51
0
votes
1 answer

differing column names in self-outer-joins

When writing a self-join in tSQL I can avoid duplicate column names thus: SELECT FirstEvent.Title AS FirstTitle, SecondEvent.Title AS FirstTitle FROM ContiguatedEvents AS FirstEvent LEFT OUTER JOIN ContiguatedEvents AS SecondEvent ON …
dumbledad
  • 16,305
  • 23
  • 120
  • 273
1 2 3
…
99 100