On this query we have our Equipment card and the Serial Number but need to add the ar invoice.
SELECT
T1.[ItemCode] AS 'Item Description'
, T1.[GrntStart] AS 'Mfr Warranty Start Date'
, T1.[GrntExp] AS 'Mfr Warranty End Date'
, T1.[LotNumber] AS 'Vin Number'
, T1.[DistNumber] AS 'Serial Number'
, T0.[custmrName] AS 'Dealer Name'
, T0.[directCsmr] AS 'End User Name'
, T0.[dlvryDate] AS 'Delivery Date'
, T0.[internalSN] AS 'Serial Number'
, T0.[drctCsmNam] AS 'End User Name'
, T1.[itemName] AS 'Item Description'
FROM [dbo].[OINS] T0 , [dbo].[OSRN] T1 WHERE (T1.[DistNumber] = T0.[internalSN] )