aşağıdakine benzer bir sorgu işinizi görebiir
ben tek sorgu olarak tasarladım ama siz 2 sorgunun birleşimi olarak da tasarlayabilirsiniz
SELECT
xSQL.ID,
xSQL.SuppNumber,
xSQL.SiteID,
xSQL.SiteName,
xSQL.SupplierName,
OrderDate,
tbl_OrderMaterials.MaterialName
FROM
(
SELECT
tbl_Orders.ID,
tbl_Orders.SuppNumber,
tbl_Orders.SiteID,
tbl_Orders.SiteName,
tbl_Orders.SupplierName,
tbl_Orders.OrderDate,
Min(tbl_OrderMaterials.ID) AS EnAzID
FROM
tbl_Orders
LEFT JOIN tbl_OrderMaterials ON tbl_Orders.ID = tbl_OrderMaterials.Order_ID
GROUP BY
tbl_Orders.ID,
tbl_Orders.SuppNumber,
tbl_Orders.SiteID,
tbl_Orders.SiteName,
tbl_Orders.SupplierName,
tbl_Orders.OrderDate
) AS xSQL
LEFT JOIN tbl_OrderMaterials ON xSQL.EnAzID = tbl_OrderMaterials.ID;
_______________________________________________________________________
yada 2 sorgu halinde
önce
AraSQL adında sorgu oluşturup aşağıda kodu girin
SELECT
tbl_Orders.ID,
tbl_Orders.SuppNumber,
tbl_Orders.SiteID,
tbl_Orders.SiteName,
tbl_Orders.SupplierName,
tbl_Orders.OrderDate,
Min(tbl_OrderMaterials.ID) AS EnAzID
FROM
tbl_Orders
LEFT JOIN tbl_OrderMaterials ON tbl_Orders.ID = tbl_OrderMaterials.Order_ID
GROUP BY
tbl_Orders.ID,
tbl_Orders.SuppNumber,
tbl_Orders.SiteID,
tbl_Orders.SiteName,
tbl_Orders.SupplierName,
tbl_Orders.OrderDate;
sonra da aşağıdaki sorguy oluşturmayı deneyin
SELECT
AraSQL.ID,
AraSQL.SuppNumber,
AraSQL.SiteID,
AraSQL.SiteName,
AraSQL.SupplierName,
OrderDate,
tbl_OrderMaterials.MaterialName
FROM
AraSQL
LEFT JOIN tbl_OrderMaterials ON AraSQL.EnAzID = tbl_OrderMaterials.ID;
dilerim işinize yarar