Sorry about that lapse.  UPDATE_DATE is in the the ZATS Table (alias Z).
ZATS as a CREATED DATE and an UPDATE DATE.  

thanks

I cheated, i think legally.........I repeated the entire where clause, with an AND between each of my three table matches.
This worked, no appreciable time hit.
Would love to know...

follow up . . . my report pull thousands for rows where L=C=Z also

thanks for the post - -

i have three tables, let's say each has a price for the identical item.
In a perfect world all three tables should contain...

removing the N's sped the query up CONSIDERABLY.. Under two minutes now compared to 30 before.

However, i get the same results even after  adding the extra ().

Thanks for the advice!  I will give them a shot . . . thanks again

Jeff

(apologies as this is continuation of my topic from yesterday)
we ended up doing that report differently. This is just educational for me so i can learn how AND WHY...

Thanks, but not sure how to do a sub query . . 🙁

Still stuck here . . . 

I’ve simplified my issue down to this:
With or without using a temp table...............

Table A
           ...

Ah, the light is flickering . . . thanks, i will try that . . . .

Thanks for your patience and quick reply!!!!!!!!!!!!!!!!

Jeff

ISnt this code joining the tables?

left JOIN [TSC].[EMS_TVC_PROD_CLASS] C 
ON #TEMP1.PD_ID = C.[PROD_ID]

"Well, you're referencing the temp table without joining to it first. "

I do not understand what this means or how to fix it . . . .thanks

Thanks
starting with...
/* Joining on Prod_Class */
left JOIN [TSC].[EMS_TVC_PROD_CLASS] C
ON #TEMP1.PD_ID = C.[PROD_ID]

I need the value (Class_value_1) from Prod_Class where #TEMP1.PD_ID = C.[PROD_ID] 

Re:

Hello,

In your example, 3PM to 5PM and then next day 8AM to 10AM = 2 + 2 = 4 Hours

You are correct, I should have said Opens at 3pm...