VIEW IN DB

By  this a virtual table called  NO_DISCOUNT IS CREATED  WITH COLUMNS  MD_NUM, QTY,PRICE THE BASE TABLE IS STOCK TABLE.

THE COLUMNS WHICH ARE NOT MENTIONED IN THE SELECT STATEMENT WILL NO BE SHOWN WHICH EXISTES IN STOCK TABLE