Hi Guys, I'm unable to generate a table for you, but hopefully, the next screenshot will give some highlights.

This is a list of people that have Office...

Sure John,

I will generate a Table DDL and provide it here so can be easy for you.

Thanks for the assistance so fat and for the clarification on the MIN and...

Hey John,

i see now, i tried your query but doesn't return anything, just blank results

SELECT
s.cs_contactyominame AS 'Contact Name'
,p.name AS 'Product Name'
,s.createdon AS 'Created On'
,s.cs_expirationdate AS 'Expiration Date'
,CASE
WHEN...

Hi John, i tried this:

select cs_subscription.cs_contactyominame as 'Contact Name',
product.name as 'Product Name',
cs_subscription.createdon as 'Created On',
cs_subscription.cs_expirationdate as 'Expiration Date',
case
when cs_subscription.cs_status=110000000 then 'Active'
end as 'Status',
MAX(product.name) as 'Monthly',
MIN(product.name) as 'Trial'
from...

• This reply was modified 5 years, 3 months ago by  radoslavov91.