0

I had to update a MSSQL db from 5 to 14, requiring a search query to be updated as well. I am new.

SELECT 
        Registry.registryID
        ,Registry.categoryID
        ,A.textImage
        ,Registry.categoryOrder
        ,B.InvName
        ,B.retail_price
        ,C.brideLastName
        ,C.brideFirstName
        ,C.groomLastName
        ,C.groomFirstName
        ,Registry.ProductID
        ,Registry.quantity
        ,Registry.quantityGot
        ,Registry.inventoryType
        ,Registry.nonInvDesc
        ,Registry.nonInvPrice
        ,Registry.nonInvDesc
        ,event.eventDate
        ,EventType.eventName
        ,event.eventID
        ,C.RegistrantID
        ,B.Desc_Short
        ,B.img_large
        ,b.Personalize_Flag
   FROM Registry,event
       LEFT JOIN registryCategory
       ON Registry.categoryID = A.regCategoryID
       LEFT JOIN products B
       ON Registry.ProductID = B.ProductID
       LEFT JOIN registrant C
       ON event.registrantID = C.RegistrantID
       INNER JOIN eventType
       ON event.eventid = #eventid#
       INNER JOIN EventType
       ON Event.eventTypeCode = EventType.eventTypeCode
    ORDER BY A.sortOrder,Registry.categoryOrder,Registry.registryID

Executing the code gives me - The multi-part identifier Registry.categoryID could not be bound.

Leigh
  • 28,765
  • 10
  • 55
  • 103
Troy
  • 1

0 Answers0