SELECT ii.invoiceid,
ii.createdate,
ii.salesid,
ii.shipdate,
ii.bol,
ii.terms,
ii.shippingcharge,
ii.discount,
ii.comments,
si.purchaseorder,
si.instructions,
si.fob,
si.createdate as salesdate,
cb.company as bill_company,
cb.address1 as bill_address1,
cb.address2 as bill_address2,
cb.city as bill_city,
cb.state as bill_state,
cb.zipcode as bill_zipcode,
cb.country as bill_country,
cs.company as ship_company,
cs.address1 as ship_address1,
cs.address2 as ship_address2,
cs.city as ship_city,
cs.state as ship_state,
cs.zipcode as ship_zipcode,
cs.country as ship_country,
p1.productno,
p1.name as productname,
sii.quantity as productqty,
iii.quantity as productqtyship,
IsNull(sii.quantity - iii.quantity, 0) As qtybackorder,
sii.price As productprice
--sii.qtyship,
--sii.qtybackorder,
--sii.price
FROM invoice_info AS ii
LEFT JOIN invoiceitem_info As iii ON ii.invoiceid = iii.invoiceid
LEFT JOIN sales_info AS si ON ii.salesid= si.salesid
LEFT JOIN salesitem_info As sii ON si.salesid = sii.salesid
LEFT JOIN customer_billing AS cb ON si.billingid = cb.billingid
LEFT JOIN customer_shipping AS cs ON si.shippingid = cs.shippingid
LEFT JOIN product_info As p1 ON iii.productid = p1.productid
WHERE ii.invoiceid = @invoiceid