Search results for query: *

The SQL Pulls the Products (Code, Description, Sale Price, Department, Etc..) from the ACCOUNTING database. I don’t have the permissions to edit this database. Add tables, drop them etc. The second database LMMISC is one I created with one table in it CustomeProductFields. I want to link the...

I couldn’t get CR8 to create the query using the Select Expert so I used the Pervasive Control Center to run “hand typed” SQL Query’s on the data tell I got something that worked at a speed I could live with. (If I did a join or union the system took way to long to complete the query. Don’t know...

The query that finaly worked is SELECT Products."Code", Products."Desc", Products."SalePrice" FROM "DEBC Lead Masters"."Products" Products WHERE "Products".Code not in (select distinct("BillingDetail".DetailNo) from "DEBC"."BillingDetail"BillingDetail where...

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')...

Thank You, Thank You, Thank You Very good guess. That was just what the problem was. The customer number is text stored as text in a text field. Now all I have to do is wait for the system to run the join on 400,000 records. Thank You for you help I truly do appreciate it. Erik

CR gives me the error "ODBC error: [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Incompatible type in predicate

First you would create a report that used one field of the same datatype as the product code field." The field is the same data type but the size is different. CR gives me the error "ODBC error: [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Incompatible type in...

I thank all for the help provided. If I find a solution I’ll post it.

Yes, their is a customer table with a customer number.

Any idea of how I could get the data I seek?

Ok there is some miscommunication. - The old report is one that looks at the customers billing detail, finds all products that they have ordered and prints that product with a blank spaces to write in so customers can use them as reorder sheets. What I am after is the inverse of that. What...

Products that don’t match products pulled by the last report?" (The one that told me the products they do order) Tell me the products that a specific customer doesn’t order? -Erik

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...