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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!