Differences

This shows you the differences between two versions of the page.

--- tilausj:sql [2018-05-14 11:48] – created krister
+++ tilausj:sql [2018-05-14 11:49] (current) – krister
@@ Line 8: / Line 8: @@
 </code>
+=== Tilaukset, tuotteet, käyttäjät (Efecten SAM-tarkistus) ===
+<code>
+select orders.id, orders.categoryName, orderproducts.name, orderproducts.enduserName, orders.division, orders.costpool, orders.ordered, orders.purchased, REPLACE(REPLACE(orders.comment, CHAR(13), ''), CHAR(10), '')
+from orders, orderproducts
+where orders.id=orderproducts.order_id
+</code>