CODEWITHSUNDEEP
mysqlsqlambiguous
Twichy Bird
Twichy Bird

Reputation: 15

SQL : i got an Ambiguous error

select [CLIENT_SUIT_ID]
  ,[CLIENT_CODE]
  ,[CARD_ID]
  ,[EXPIRE_DATE]
  ,ROW_NUMBER()over(partition by CARD_ID order by CARD_ID ASC)
from [KSS_TMP].[dbo].[CLIENT_SUIT] as Tab1 JOIN 
    (SELECT CARD_ID FROM [KSS_TMP].[dbo].[CLIENT_SUIT] 
     where CLIENT_CODE NOT LIKE '080%' AND CARD_ID != '-' 
     GROUP BY CARD_ID 
     HAVING COUNT(CARD_ID) > 1 ) as Tab2 ON Tab1.CARD_ID = Tab2.CARD_ID

when i tried to execute this code i got an "Ambiguous column name 'CARD_ID'. What did i do wrong here?

Upvotes: 0

Views: 147

Answers (1)

Jeruson
Jeruson

Reputation: 125

Add the table name on each select of CARD_ID, something like SELECT Tab1.CARD_ID FROM ...

Upvotes: 1

Related Questions