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
1 answer

Full outer join on multiple fields

I have several tables of academic journal rankings, from different sources and with different citation metrics. I want to combine them in a single table, aggregating data by journal. For example, the first table has columns: ISSN1 ISSN2…
AndreA
  • 295
  • 2
  • 12
0
votes
2 answers

Alternate to NOT IN in mysql where query has inner join

I got a situation where I want to get the data from one database table which are not in other database table. For that I am using NOT IN clause. This works fine for small amount of data. When tables have large data it takes huge time. I checked for…
Rahul Tapali
  • 9,887
  • 7
  • 31
  • 44
0
votes
2 answers

Right Outer join issue

I've two tables that I want to join and filter data from. I used a stored procedure to do that. My intention is to bring every item from the second table (i.e Department) even if they don't have a matching record in the first table (i.e. Employee)…
aby
  • 810
  • 6
  • 21
  • 36
0
votes
1 answer

if statements inside outer apply or case when

is it possible to have if statements inside an outer apply? I can't seem to get it work. this is the existing code that works: select id from residentmemberlease rml left outer join lease l on rml.leaid = l.leaid outer apply (SELECT TOP(1) * FROM…
edsamiracle
  • 753
  • 3
  • 12
  • 27
0
votes
2 answers

How can I get join not duplicate?

I get join 2 tables but use 3 table. I need not duplicate values. But I try join have duplicate. Table peopleAll: pNo pName ------------- 00001 Sang 00002 Janta 00003 Els 00004 Est 00005 Sam 00006 John 00007 Misan 00008 Wila 00009 …
nettoon493
  • 17,733
  • 7
  • 30
  • 45
0
votes
3 answers

Multiple columns in Linq left outer join

Could somebody help me complete this linq left outer join query so that the second column of the right table (tempData) is contained in the result set even though it may be null? sortedData = From cs In mbCustomSort Order By cs(0) …
groobie
  • 1
  • 1
0
votes
1 answer

How show datetime select only in Sql Server?

I need show datetime when I select datetime only. Because I try to run SQL but show all datetime. Table Emp: EmpNo fullName 00001 Midna 00002 Klog 00003 Porla 00004 Seka 00005 Mila Table tFile: EmpNo cDate …
nettoon493
  • 17,733
  • 7
  • 30
  • 45
0
votes
1 answer

Use SQL query with a join clause in a view

Is it possible to create a database view that emulates the select query below? select A.Name, B.Subscription from TestTableA as A left outer join TestTableB as B on A.ID = B.A_ID and Subscription = 'xxxx'; With a view I can't see how I can…
sipsorcery
  • 30,273
  • 24
  • 104
  • 155
0
votes
1 answer

extractValue and right outer join - Oracle SQL

i got a little (at least i hope so) problem with an SQL Query. Here's my join WHERE obj.mod_type = 'SER' and obj.wrk_id=wrk_lang.id(+) and extractvalue(value(shm),'/*/@xmi:id','xmlns:xmi="http://www.omg.org/XMI"') =…
FredM
  • 41
  • 1
  • 2
  • 10
0
votes
2 answers

Mysql JOIN with IN and multiple results of RIGHT table

The LEFT table (simplified) is: id name (ex:Bob) tags (ex:1,4,6) The RIGHT table is: id tag (ex:Sailing) I want to get the results of the LEFT table like this: row 1: name: Bob tags: Sailing,Snowboard,... The closest I got was there: SELECT…
NaturalBornCamper
  • 3,675
  • 5
  • 39
  • 58
0
votes
3 answers

SQL fill days for dates not found in Database

I'm getting data from my function as follows: Date | Number 06-02-2012 | 2 06-05-2012 | 5 06-08-2012 | 5 If i want to include all dates that are not found in DB in the following matter how would i do it?: Date | …
Jey
  • 37
  • 1
  • 7
0
votes
1 answer

outer join modelisation in django

I have a many to many relationship table whith some datas in the jointing base a basic version of my model look like: class FooLine(models.Model): name = models.CharField(max_length=255) class FooCol(models.Model): name =…
chub
  • 767
  • 6
  • 11
0
votes
4 answers

SELECT * FROM tableA, tableB WHERE Conditions [+]

I have the following query SELECT * FROM tableA, tableB WHERE Conditions [+] What does this keyword Conditions[+] Stands for? How this query behaves as a outer join?
wali
  • 229
  • 4
  • 8
  • 21
0
votes
1 answer

MySQL Bug? mixing LEFT and RIGHT joins to list articles within categories, including empty categories

I have articles, which belong to article_types, which belong to categories. Each article has a format. I want to list all articles published by a particular author, grouped by category. I want to show all categories, even the ones with no…
afsk
  • 81
  • 4
0
votes
3 answers

How do I return two columns from first table if only one column partially matches with the second one?

select art.artno, art.name from Art left outer join store on art.artno =store.artno where art.Artno not in (select art.artno from store) The query is supposed to be like this but seems not working(I do not get any result rows beside the column…
tough
  • 301
  • 1
  • 7
  • 14
1 2 3
…
99 100