Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Change Custom SQL Query with multiple data sources
CR8 & Pervasive.SQL 2000i The query SELECT Products."Code", Products."Desc", Products."SalePrice" FROM "DEBC"."Products" Products WHERE "Products".Code not in (select distinct("BillingDetail".DetailNo) from "DEBC"."BillingDetail"BillingDetail where "BillingDetail".CVNo='619383')...- ERKcool
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
What products are customers not buying?
CR v8 I have 2 tables Billing.Detail (invoice #, customer number, product code, description, order quantity, sale price, etc…) Products (products code, description, text2, amount1, amount2, etc…) Tables are linked by product code. I can get it to tell my what products a given customer...- ERKcool
- Thread
- Replies: 19
- Forum: Business Objects: Crystal Reports 4 Other topics
