Databases
StackOverflow2013
Postsdbo
PO>, <, <>, = Operators for Inner Join Conditions
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO>, <, <>, = Operators for Inner Join Conditions
    primarykey
    data
    text
    <p>My boss threw this code my way and I am having a hard time understanding how the inner join's last ON statement works. I don't think he understands it completely either (but it gets the job done). Really just interested in learning more about how SQL works. Thank you so much!</p> <p>Here is the On Statement</p> <pre><code>and (A.Submitted_Date &gt; X.Submitted_Date))) </code></pre> <p>And here is the query</p> <pre><code> SELECT AA.ID, AA.Submitted_Date as Date_Status FROM Report as AA where AA.Submitted_Date in --START ( SELECT X.Submitted_Date FROM Report as A inner join --Start Find All Dates Submitted ( SELECT [ID],[Submitted_Date] FROM Report where not(Submitted_Date is null and Cleared_Date is null) group by ID, Submitted_Date) as X --End Find all Dates Submittd --below is the conditions of the join ON A.ID = X.ID and A.ID= AA.ID --THIS IS THE CONDITION I AM CONFUSED ABOUT!!!! and (A.Submitted_Date &gt; X.Submitted_Date))) group by X.Submitted_Date) and not AA.Submitted_Date is null group by AA.ID, AA.Submitted_Date </code></pre> <p>Here is a Sample of Dates From Table A</p> <pre><code>2012-11-27 00:00:00.000 2012-11-27 00:00:00.000 2012-11-27 00:00:00.000 2012-12-10 00:00:00.000 2012-11-27 00:00:00.000 2012-11-27 00:00:00.000 2012-11-29 00:00:00.000 2012-12-05 00:00:00.000 2012-12-12 00:00:00.000 </code></pre> <p>Here is a Sample of Dates from Table X</p> <pre><code>2012-11-27 00:00:00.000 2012-11-29 00:00:00.000 2012-12-05 00:00:00.000 2012-12-10 00:00:00.000 2012-12-12 00:00:00.000 </code></pre> <p>Here is the Result before The Last Condition</p> <pre><code>2012-11-27 00:00:00.000 2012-11-29 00:00:00.000 2012-12-05 00:00:00.000 2012-12-10 00:00:00.000 2012-12-12 00:00:00.000 </code></pre> <p>Here is the result with A.Sub > X.Sub</p> <pre><code>2012-11-27 00:00:00.000 2012-11-29 00:00:00.000 2012-12-05 00:00:00.000 2012-12-10 00:00:00.000 </code></pre> <p>I am confused on why those dates show up. What is being compared between A and X? Won't the values in A be the same as X always, therefore resulting in no final data? Thank you for your help!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKyle Copeland
    1. USKyle Copeland
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PO>, <, <>, = Operators for Inner Join Conditions
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO>, <, <>, = Operators for Inner Join Conditions
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO>, <, <>, = Operators for Inner Join Conditions
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIMHO it would be clearer if this condition was in WHERE clause. However, I'm not sure that the execution plan would be the same.
      singulars
      1. PO>, <, <>, = Operators for Inner Join Conditions
      1. USLuc M
    2. COI think we need to know more about your Report table to answer this completely. Can you update your question so the sample data from X and A also has the Report.ID's. I have an idea of what is happening but i can't say without seeing the ID's as they're part of the join condition.
      singulars
      1. PO>, <, <>, = Operators for Inner Join Conditions
      1. USFodagus
    3. COThe resulting data is from one id. So think of this result set as having a where statement at the bottom where id = '111'; Thank you for trying to help!
      singulars
      1. PO>, <, <>, = Operators for Inner Join Conditions
      1. USKyle Copeland
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload