AnsweredAssumed Answered

Need Help with Execute Sql Statement

Question asked by Lemmtech on Feb 23, 2015
Latest reply on Feb 26, 2015 by beverly

I have a customer table and an orders table and I need to do a few things.

 

1] Total just the last 2 years worth of sales orders for a customer

 

2] Show the last date a quote was entered into the orders table. There is field called "Type" and it's either a sale or a quote

 

I hope I have made myself clear.

 

Thanks for you help,

 

Mark L

LemmtechEnterprises

markl@lemmtech.com

Outcomes