dbForge Studio issue

[LiPo]

Hi, I am creating TSQL UPDATE command where i need to compare two tables field by field and set changes, but suggest info does not work.

Example of TSQL UPDATE:

Code: Select all

 UPDATE dbo.tbl1
 SET
    field1 = tbl2.field1
    Here suggest list is not working, when I am writing text there is no field list
  ...
  FROM
    tbl1
    JOIN tbl2
      ON tbl1.ID = tbl2.ID 

  WHERE
  tbl1.field1 <> tbl2.field1 OR
  ...

Thank you for advice
L

[alexa]

Please check that you have selected the correct database in the 'Database' dropdown menu on the 'SQL' toolbar.

Also, please make sure you put a comma after:

Code: Select all

field1 = tbl2.field1