How To Use LIKE With Column Name

SQL如何透過WHERE LIKE將二個資料表的值串連


SQL Server：
SELECT COUNT(*),A.APT_CD FROM HOTEL H, AIRPORT A
WHERE A.HOTEL_DEST_CD  LIKE '%'+H.DEST_CD+'%'

閱讀更多：
https://stackoverflow.com/questions/1398720/how-to-use-like-with-column-name