Skip to Content
0
Former Member
Jan 03, 2008 at 05:50 AM

Help required please - can't work out how to do this

31 Views

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.