13 lines
219 B
SQL
13 lines
219 B
SQL
-- name: CreateSaleOrderDetail :one
|
|
INSERT INTO sale_order_detail (
|
|
sale_order_id,
|
|
product_id,
|
|
product_name,
|
|
quantity,
|
|
sub_total,
|
|
product_price,
|
|
profit
|
|
) VALUES(
|
|
$1, $2, $3, $4, $5, $6, $7
|
|
)
|
|
RETURNING *; |