I have created two tables. One is Item_Master table with the fields Itemno having Primary key and must begin with letter ‘I’, Item_Name(HDD, MONITOR, CDROM, KEYBOARD, UPS), Stock defined as Not Null and Price which is greater than 10000 and less than 30000.
Another table is Item_Trans with the fields Itemno referencing the Item_Master table, Quantity greater than 25 and Trans_Date.
How do I perform the following Query?
Display the Itemno, Item_Name, Quantity, Trans_date where the transaction date greater than March 2008
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!