Hi all,

First post here. I am fairly new to SQL, but need better data to do my usual Excel analysis.

My current company use Sage Business Vision for its operations software. The sage preferred DB is Pervasive, wich is what is what is available on our server.

My task, find all products from sales_hist_detail that have been bought by one and only one particular customer (our largest) Customer info is located in the sale_hist_header file key is invoice_no.

It is easy enough to find all products sold by one customer but I am having a heck of a time getting my head around finding all products sold by one and only one specific customer. Keep in mind that that one customer may have several order records of the product but they are the only one to have ordered it.

Any help would be greatly appreciated as I am still struggling with basic group by and join functions. I will get there but I would like to find an answer to this one rather quickly.

Thank You