Stack Overflow
Stack Overflow

Questions tagged [right-join]

The RIGHT JOIN keyword will return all the rows from the right table, even if there are no matches in the left table.

SQL RIGHT JOIN ON returns the rows of INNER JOIN ON plus unmatched right table rows extended by NULLs. A consequence is that it returns all the rows from the right table at least once even if there are no matches in the left table. See examples here.

233 questions
0
votes
1 answer

msyql union of left and right join plus where conidtion not working

Lets say I have two tables in MySql. value (Address Field Values) field (Address Fields) It might be some people (user_id in the value table) have not filled out all addressFields. which means that they have only values for some fields. To retrieve…
gb5256
  • 191
  • 11
0
votes
3 answers

SQL - no output from Right Join

I have one table which I select with the code: Code A Select TDS, TL, IK From (Select Sheet1.TOOLING_DATA_SHEET As TDS, Sheet1.CUTTING_TOOL As TL, ENT_ITEM_MASTER.ITEM_KEY As IK From Sheet1 Inner Join ENT_ITEM_MASTER On…
user4888
  • 101
  • 1
  • 12
0
votes
1 answer

SQL One row that has multiple joins from different columns

Mapping Table Desciption ToID FromID Map A 2 1 BaseTable Id, Deccription, subTypeID 1 ValueA 9 2 ValueB 10`enter code here` SubTypeTable id Description 9 SubType 9 10 Subtype 10 What I want to return is the…
MicroMan
  • 1,988
  • 4
  • 32
  • 58
0
votes
2 answers

Joined two tables & get results

I'm having some trouble with joining two mysql tables & getting the result as I want. I have two tables , users table & times table. Users table is having id & name . time table is having user_id & minutesSpent. I want to get the times for all the…
Udaya Sri
  • 2,372
  • 2
  • 25
  • 35
0
votes
1 answer

Combining UNION ALL and OUTER JOIN in SQL Statement

I've got two queries, one uses a union all function. select * from ( Select ticket_id as Ticket_Num , name as Name , approved_at as Approval_Date , price as Price , quantity as Quantity , (price * quantity) as Cumulative_Price From…
Kjbojang1es
  • 47
  • 2
  • 8
0
votes
3 answers

Which JOIN type in multiple joins

I have 4 tables that I want to be joined. Customers Traffic Average Live I want to insert joined data of these tables to "Details" table. The relationship between the tables is here: each of Traffic, Average and Live tables have a "cid" that is…
Bayan B
  • 97
  • 15
0
votes
1 answer

How to formulate query to show all courses taken by a person

I'm having trouble formulating a MySQL query correctly. Everything I've tried doesn't give me what's needed, or gives a syntax error. I have three tables: Clients, Courses, and CoursesForClients. The Clients table just has basic coordinates for a…
Lew
  • 1,431
  • 1
  • 16
  • 22
0
votes
0 answers

Equivalent expression to MySql Left Join

I'm working on my website and I'm stuck on writing MySQL query which uses "LEFT JOIN" syntax. A simple example of my query is shown bellow: SELECT p.surname, f.f_path as players_image FROM player p LEFT JOIN file f ON p.id_image = f.id_file The…
Kalvis K
  • 85
  • 1
  • 10
0
votes
1 answer

Order of joins for NHibernate

I have a problem with Nhibernate - it puts right join in the middle of other joins. Here is my code: private DetachedCriteria GetBaseCriteria() { return DetachedCriteria.For("foo") .CreateAlias("foo.Bar", "bar") …
JleruOHeP
  • 10,106
  • 3
  • 45
  • 71
0
votes
1 answer

Null values with all types of OUTER-JOIN is it me or is this normal? using Oracle db11g

I got a problem with something and I don't know if the thing I am doing is right.. or deadly wrong. I am working with the outer-join concept. In my case with all the three of them. As I am typing my query's I get 50% viewable values en 50% null…
Maxime de Lange
  • 287
  • 2
  • 7
  • 21
0
votes
1 answer

Trying to insert values from one table to another where a surrogate key match is not found

I am trying to simulate a full outer join, comparing two tables against each other. The batch_import table contains records that need to be inserted, only if they don't exist in the employees table. To do this I have tried the following…
dickturnip
  • 387
  • 2
  • 4
  • 14
0
votes
1 answer

Right Join / Group by query

I have a (SQL Server) Right Join / Group by query designed to return all weeks of the year (week beginning) with a count of the number of projects that are delivered within each week. The query runs against two tables; WeeksOfyear (where the field…
acgt1008
  • 3
  • 1
  • 2
0
votes
0 answers

CActiveDataProvider returns Empty Array

I am getting empty array from CActiveDataProvider, while (property) totalItemCount returns 2. I have 'enableParamLogging'=>true, in my config, and enabled CWebLogRoute. When I execute the generated query by CActiveDataProvider I get 2 rows, but…
Ramzy
  • 56
  • 1
  • 9
0
votes
0 answers

MySQL query return all rows from single table regardless of matching rows elsewhere

I'm trying to achieve MySQL's version of a FULL JOIN with no luck. My results need to include ALL rows from 'users' whether or not the user has matching rows in the other tables. Right now my results are not all due to nature of LEFT JOIN but when I…
Klav
  • 405
  • 1
  • 9
  • 19
0
votes
4 answers

SQL join to retrieve multiple lines in right table

I'm new to SQL and trying to find the correct join to use in this situation. Table A contains a series of unique (i.e. no repeats) IDs. Table B contains multiple measurements for each ID, including IDs that don't exist in table A. I need a combined…
thornate
  • 4,902
  • 9
  • 39
  • 43
1 2 3
…
15 16