I thought it would need the AND operator because you need a price filter and then the vender check. But I see that the UNION is joining 2 separate...

got it. thanks : )

When you say

. What does aggregate mean in this context? I...

ok thank you helps a ton

Got it thanks for the insights : )

Great thank you ..helps a ton for me

Thank you ...Tremendous help for me

Sorry the my example and code did not post correctly due to me. Here is my example and 2 questions:

SELECT customers.cust_name,

customers.cust_id,

Count(orders.order_num) as num_ord

FROM customers INNER JOIN orders

ON customers.cust_id =...

Great. Thank you and I can't tell you how much I appreciate the help : )

Hey all, thanks for the feedback, i'm not quite there yet... Trying to simplify how I'm stating my need:

This is what my table looks like:

Customers

Name, Date

‘John’, ‘2015-01-01’

‘John’, ‘2015-01-02’

‘John’, ‘2015-01-05’

‘John’,...

awesome..thank you for the great help!!

Hi Gail,

My question was referring to converting row data to column data. I am trying to get a sense of how "wide" SQL can go without it crashing....

yes, weekend dates will be excluded so there will be gaps in the date ranges

Thanks for the blue links..will review and adjust

great thanks...Also what is the maximum number of columns that can be used in a large data set? "Large" meaning 5 columns by 20 million rows?