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

Popular posts from this blog

ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

Matlab transpose a table vector -

c# - Textbox not clickable but editable -