SELECT orderID,orderTitle,orderBunrui, orderImage,tateyoko,orderToppage,orderPerson,orderHyouji,orderNarabe,tourokudate FROM Orders WHERE orderPerson="野町和嘉" AND orderBunrui='Lphoto' AND orderHyouji ='OK' ORDER BY orderNarabe ASC,orderID ASC SELECT orderID,orderTitle,orderBunrui ,orderToppage,tourokudate FROM Orders WHERE orderPerson="野町和嘉" AND orderBunrui ='gallery' AND (orderHyouji ='OK' OR orderHyouji ='OK2') ORDER BY orderID ASC SELECT t.ItemID, t.CategoryID, t.SupplierID, t.ItemName, t.ItemDiscrip, t.ItemComment1, t.ItemPrice, t.ItemImage, t.ItemImage1, t.company, t.bumon, t.name, t.bunrui, t.tourokudate, t.kousindate, t.hyouji, t.narabe, t.tateyoko, o.orditmID, o.orditmNarabe, o.orditmOrderID, o.orditmItemID, o.orditmQty, d.orderCompany,d.orderID, d.orderCustID, d.orderTitle, d.orderComment,d.orderImage,d.orderPerson,d.orderPage FROM Orders d, OrderItems o, Items t WHERE d.orderPerson="野町和嘉" AND t.ItemID = o.orditmItemID AND d.orderID = o.orditmOrderID AND d.orderBunrui='Lphoto' AND d.orderHyouji ='OK' PHOTOGRAPHY Kazuyoshi Nomachi 野町和嘉『写真』













SELECT t.ItemID, t.CategoryID, t.SupplierID, t.ItemName, t.ItemDiscrip, t.ItemComment1, t.ItemPrice, t.ItemImage, t.ItemImage1, t.company, t.bumon, t.name, t.bunrui, t.tourokudate, t.kousindate, t.hyouji, t.Tophyouji ,t.narabe, t.tateyoko, o.orditmID, o.orditmNarabe, o.orditmOrderID, o.orditmItemID, o.orditmQty, d.orderID, d.orderCustID, d.orderTitle, d.orderComment FROM Orders d, OrderItems o, Items t WHERE t.ItemID = o.orditmItemID AND d.orderID = o.orditmOrderID AND d.orderID=#orderset2.orderID# AND t.tateyoko='YOKO'
--->