Share
Report
65My current problem is I'm getting back a 0 from values that you can tell from the image are obviously in the database tables.
From what I've seen in the relations the link between my table PdsBatchAttributes and VMVinInfo is VMVinInfo.VINNumber to PdsBatchAttributes.InventBatchId.
Upon receiving zeros, to double check this, I went and grabbed the value from the pds table and inserted it into the VINumber field on VMVinInfo. I found a matching record as you can see in the image.
I then went to the VIN dashboard to make sure the value 'FRU00001H718' being sent would be picked up by VMVinInfo AND pdsBatch but I'm getting 0's
I have two instances of the SalesTable (slsTable & salesTable).
The current instance I'm using for this particular query is salesTable.
P.S. I also recently used another solution provided through a similar question I asked. Outer joins and re-adding queries helped me solve the problem. I am no closer to retrieving that data I obviously see though. But I will link it in case it helps anyone solve this problem or for a less experienced developer in the future. SQL query returning 0's
All responses (
Answers (
