2013-04-16

엑셀에서 쿼리짤때

VLOOKUP(Y4,Sheet3!$A$1:$B9,2,FALSE)


=CONCATENATE("INSERT INTO MTRL_INFO (MTRL_NO,"&A1&","&D1&","&F1&","&G1&","&H1&")")

=CONCATENATE("VALUES (SQ_MTRL_INFO.NEXTVAL,"&A4&","&D4&","&F4&","&G4&","&H4&");")

댓글 없음:

댓글 쓰기