how to create query or use below table how to create selectstatement.
WHSWorkTable wHSWorkTable;
WHSWorkLine wHSWorkLine;
PwCAdviceMainTable pwCAdviceMainTable;
PwCRTWInquires pwCRTWInquires;
SalesTable salesTable;
CustTable custTable;
EcoResProductCategory ecoResProductCategory;
inventtranferjour inventTransferJour;
InventItemBarcode inventItemBarcode;
PwCItemApproval pwCItemApproval;
Hi,
Please explain in detail.
You want to write select statement between these tables with the relations in between them.
Regards,
Bharath K
s
Hi Sree,
while select inventsum
where inventsum.ItemId == inventsum.ItemId
//inventsum.ItemId == inventsum.ItemId
join inventtablemodule
where inventtablemodule.itemid == inventsum.itemid
&& inventtableModule.ModuleType == ModuleInventPurchSales::Invent
join reqitemtable
where reqitemtable.itemid == inventsum.itemid
{
I think you are having some custom tables in your ax.
You can modify the above code to your requirements with your custom tables.
Regards,
Bharath k
Providing a list of tables and asking for a select statement doesn’t make any sense. Make sure that you describe your requirement clearly, so that others will not waste their time in extracting the requirement from you. Hope you can understand that.