update station
set is_visible = 1 from station a inner join line b on a.line_no=b.line_no and a.station = b.station and a.id= b.id where b.is =1
提示我from这个错误?是啥子问题
set is_visible = 1 from station a inner join line b on a.line_no=b.line_no and a.station = b.station and a.id= b.id where b.is =1
提示我from这个错误?是啥子问题
set a.is_visible = 1
where b.is =1
如:
update table1 a,table2 b set a.value=1 where a.id=b.id and .......
update a ,b set a.colum=b.colum where a.id = b.id