java - mysql query error insert joined select -
Hello, I have a problem on your mysql query, I want to put the results of some queries and other data < p> this is my query check and please advise me
Tibi_auto_ BAN (Memo, REG_DATE, USER_ID, NAME, PHONE_NUM) include values ( 'test', now (), SELECT a.USER_ID, a .NAME, a BA as a INNER Join TB_CONTACT_GROUP as TB_CONTACT the .CONTACT_NUM GROUP_CONTACT_SEQ = b.GROUP_CONTACT_SEQ where b.USER_ID = 'spark@naver.com' and b.GROUP_CONTACT_SEQ = 12000)
itemprop = " text ">correct syntax is given below:
Tibi_auto_ BAN (Memo, REG_DATE, USER_ID, NAME, PHONE_NUM) INSERT SELECT 'test', now (in), a.USER_ID, a Join an INNER as TB_CONTACT from .NAME, a.CONTACT_NUM, as a TB_CONTACT_GROUP b.a. GROUP_CONTACT_SEQ = b.GROUP_CONTACT_SEQ where b.USER_ID = 'spark@naver.com' and b.GROUP_CONTACT_SEQ = 12000
Comments
Post a Comment