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