I would like to solve this following complex script in SQL by using Visual Basic, either version 5.0 or 6.0.
My first table name is tblClient, with fields ClientID and ClientName. My second table name is tblPurchase, with fields ClientID, Item Name, Qty and Price. I would like to pass one SQL query and receive a DOS output along the lines of:
Client ID: _____
Client Name: _____
Item Purchased Qty Price
Is there a simple way to go about this?