Hello every member,
I have three tables. Items in each table as follow:
1-product (id, productcode, name, packagesize, balance, groupid)<br />
2-productgroup (groupid, groupname)<br />
3-purchaseorder ( id, ponumber, productcode, podate, outstandingbalance, balanceorder)
I have Join two table (product and purchaseorder by sum column(outstandingbalance) which item that duplicated as code below:
DIM da AS NEW OLEDB.OLEDBDATAADAPTER("SELECT P.productid, P.fullcode, P.productname, P.packagesize, P.pcsperctn , sum(PO.outstandingbalance) AS [PurchaseOutstanding], P.balanceinstock, P.supplier from product P left outer join purchaseorder PO on P.fullcode=PO.productcode group by P.productid, P.fullcode, PO.productcode, P.productname, P.packagesize, P.pcsperctn,P.balanceinstock, P.supplier", cn)
but I try to join three together ( 3 table) as below:
DIM da AS NEW OLEDB.OLEDBDATAADAPTER("SELECT P.productid, P.fullcode, P.productname , P.packagesize, P.pcsperctn , sum(PO.outstandingbalance) AS [purchase], P.balanceinstock, P.supplier, G.groupname from productgroup G, product P left outer join purchaseorder PO on P.fullcode=PO.productcode where P.groupid=G.groupid group by P.productid, P.fullcode, PO.productcode,P.productname,P.packagesize, P.pcsperctn,P.balanceinstock, P.supplier, G.productname", cn)
and then I have run the application so I get error like this " Join expression not supported. "
Thank & Regards
VISAL