DB SQL 공부
# 건물, 층 , 호실 / 검색 LIKE 사용SELECT A.BULD_PK ,A.FLT_NM,A.RM,B.FLOOR_PK, B.FLOOR_NM,B.RM,C.HOSIL_PK ,C.RMFROM flt_buld A , flt_floor B , flt_hosil CWHERE A.BULD_PK = B.BULD_PK AND C.FLOOR_PK = B.FLOOR_PK AND A.FLT_NM LIKE '%빌딩%'; # 건물, 층 , 호실 / 검색 0 , 1 , 2SELECT A.BULD_PK ,A.FLT_NM,A.RM,B.FLOOR_PK, B.FLOOR_NM,B.RM,C.HOSIL_PK ,C.RMFROM flt_buld A , flt_floor B , flt_hosil CWHERE A.BULD_PK = B.BULD_P..