I doubt if you will be able to tell without seeing the data, but I thought I would ask anyways.
Below is my Query it should return all records in the VDC table of which there are 2647 instead all I get is 2466 and only on records that match. What am I missing in the query I don't see it.
SELECT tblCable.strCableID, tblCable.strCableType, tblCable.numCableLength, tblCable.keyEquipUp, tblCable.keyEquipDn, VDC.Panel, VDC.Cable, VDC.Cable_Length, VDC.Circuit_name, VDC.UpStreamCable, VDC.FPN, VDC.Load_Type, VDC.Phase, VDC.ID
FROM VDC Left JOIN tblCable ON VDC.Circuit_name = tblCable.strCableID
WHERE tblCable.keyShip=8
order by VDC.ID