MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
SELECT dbo.supplierOrder.sectionID, dbo.supplierOrder.supplierID, dbo.supplierOrder.supplierOrderNo, dbo.supplierOrder.supplierOrderCreated, dbo.supplierOrder.supplierOrderConfirmStatus, dbo.supplierOrderDetails.productID, dbo.supplierOrderDetails.orderQty, dbo.supplierOrderReceive.invoiceno, dbo.supplierOrderReceive.supplierInvoiceno, dbo.supplierOrderReceive.ID, dbo.supplierOrderReceiveDetail.qtyArrived FROM dbo.supplierOrder INNER JOIN dbo.supplierOrderDetails ON ( dbo.supplierOrderDetails.supplierOrderID = dbo.supplierOrder.ID) INNER JOIN dbo.supplierOrderReceive ON ( dbo.supplierOrderReceive.supplierOrderID = dbo.supplierOrder.ID) INNER JOIN dbo.supplierOrderReceiveDetail ON ( dbo.supplierOrderReceiveDetail.supplierOrderReceiveID = dbo.supplierOrderReceive.ID) WHERE dbo.supplierOrder.ID = 1 ;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Executing Stored Procedure with optional parameteres, returning a recordset From MS Access 2013||12||72|
|export sql server dbs||2||22|
|HIghlights of SSIS?||3||40|
|SQL Server set parent recort in select with row number||8||18|
Join the community of 500,000 technology professionals and ask your questions.