100
I have table name A in
| AID | |
| 1252 | |
| 1253 |
Table A
| AID | BId |
| 1252 | 426 |
| 1252 | 427 |
| 1253 | 471 |
| 1253 | 472 |
Table B
| BId | name |
| 426 | nava |
| 427 | lava |
| 471 | java |
| 472 | rava |
Table C
Here how can i get all names in C Table am getting only two names how to query
*This post is locked for comments
Damn! Edit button not working on Android so adding another comment instead.
If you are able to get desired result with crossCompany, kindly understand it's working and whether you should use the cross company table records for further processing in your code. Ideally each record should be processed in its own company due to various underneath business logic and validations.
CHECK if this logic works.
While select TableA join TableB where TABLEA.AID==TABLEB.AID join TableC where TABLEC.AID==TABLEB.AID
{
info(TABLEC.NAME);
}
Also if you are checking the data from SQL, Kindly check if the DATAAREAID of all records are same, otherwise use "crossCompany" keyword in the query if they are not to get the desired result.
I don't know your data, therefore I can't comment on how many records the query should return. But I suspect that you didn't debug the problem correctly. I assume that the query returns multiple records, but your code inside the loop overwrites the same productReceiptTmpLine record over and over and you end up with inventSerialId and inventBatchId of the last transaction.
Please use the debugger to verify whether it's the case.
while select inventtrans
where vendPackingSlipTrans.PackingSlipId==inventTrans.PackingSlipId
join inventDim
where inventtrans.inventDimId==inventDim.inventDimId
{
productReceiptTmpLine.inventSerialId = inventDim.inventSerialId;
productReceiptTmpLine.inventBatchId = inventDim.inventBatchId ;
}
Actually this but am not getting multiple lines only one line is coming for one serial number
You mention getting data from table C only, but why did you show the other tables? Don't you want to join all three tables?
Regarding why your current code returns only two records, you'll have to show us your code. Finding bugs in unknown code is very difficult. Also, please tell us which two names are returned.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (