Post Author: mavrick5
CA Forum: Data Connectivity and SQL
Maybe I am just having a mental blank but I need to write a report that does the following. We have a sales header and sales detail file. The key to the header file is the transaction number. The transaction number is one of the keys for the detail file. I need to be able to select the details of all transactions that may have contained products from a specified department. eg. a customer bought eggs on a transaction, what else was purchased on the same transaction. Management want to know what complimentary products are sold with our premium products. Now, I know I could do this with a subquery. However, we are using MySQL 3.51 and it does not support subqueries.