请更正插入语句 [英] Please correct the insert statement

问题描述

insert into  ETiP LEFT OUTER JOIN TIMP where
  TIMP.tid = ETiP.tid and ETiP.amount = '0' .left outer join EMP
  ETiP.emp_id = EMP.em_id

推荐答案

您需要引用以下内容:
http://msdn.microsoft.com/en-us/library/aa933206 (v = sql.80).aspx [ http://msdn.microsoft.com/en-us/library/ms188263 (v = sql.105).aspx [如何问一个好问题? [ ^ ]

You need to refer this:
http://msdn.microsoft.com/en-us/library/aa933206(v=sql.80).aspx[^]
http://msdn.microsoft.com/en-us/library/ms188263(v=sql.105).aspx[^]

..and more importantly How to ask a good question?[^]

将数据插入表中，

遵循以下语法

插入
TABLE-NAME ( COLUMN-NAME1，COLUMN-NAME2，... )
值 ( VALUE1，VALUE2，... )

例子

插入
ETip ( TipId，TipDesc )
values( 1，''hello'' )

祝您编码愉快！
:)

to insert data in table,

follow this syntax

Insert into
TABLE-NAME ( COLUMN-NAME1, COLUMN-NAME2,... )
values (VALUE1,VALUE2,...)

example

Insert into
ETip(TipId,TipDesc)
values(1,''hello'')

Happy Coding!
:)

嗨...

你能像下面的查询一样尝试吗?

Hi...

Can u please try like below query.

update ETiP set amount='0' from ETiP a  join TIMP b on a.tid=b.tid 

这篇关于请更正插入语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！