Skip to Content
0
Feb 23, 2023 at 03:59 PM

Need to add AR invoice to this query but getting Multi part Identifier error

191 Views

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] )