I’m getting error in this below line, CREATE VIEW reorder_view AS SELECT a.S_CODE AS S_CODE, a.CODE AS CODE, a.PRCT_TYPE AS PRCT_TYPE, b.VENR_CODE AS VENR_CODE, b.MATERAL_CODE AS MATERAL_CODE, b.ORDER_LEVEL AS ORDER_LEVEL, c.SUPPL_NAME AS SUPPL_NAME, sum(a.QTY) AS TOTAL_QTY FROM ((storage a join supplier_items b) join supplier_info c) WHERE b.MATERAL_CODE = a.S_CODE AND b.VENDR_CODE = c.VENDR_CODE GROUP BY a.S_CODE, c.VENDR_CODE HAVING TOTAL_QTY <= b.ORDER_LEVEL ; error msg: ‘CREATE VIEW’ must be the first statement in a query batch., Incorrect syntax near ‘)
Read MoreMonth: December 2021
Shangri La 2021 Updates: What’s Changed On The Site
Shangri La Casino is a site that captivates from the first minute with its laconic design and convenient usability. After the 2021 update, the portal has become even more stylish and easier to use. The logo and fonts have also changed, they are now better in line with the trends and make the site nicer. Sorting and searching are also more convenient. You can find the game you want in a couple of clicks. The more you learn Shangri La Live Online Casino, the more you want to stay and…
Read More