Search results

  1. L

    UPDATE query using INNER JOIN across multiple databases

    ...or this sample: UPDATE [;Database=C:\data.mdb;PWD=xyz].Table1 AS T1 INNER JOIN Table2 ON T1.ID=Table2.ID SET T1.Field1=Table2.Field2 WHERE Table2.Field3='something' working corectly only in MS Access 2010, but in my C++ Builder 6 or RAD Studio XE3 I have this error (I use ADO componets)...
  2. L

    Export several queries to one exce sheet

    Try this for example: SELECT * INTO [OS] IN 'C:\sample.xls' [Excel 5.0;] FROM Table WHERE WhatDoYouNeed
  3. L

    UPDATE query using INNER JOIN across multiple databases

    I have trouble with this query: UPDATE Table1 IN '' ';Database=C:\data.mdb;PWD=xyz' AS T1 INNER JOIN Table2 ON T1.ID=Table2.ID SET T1.Field1=Table2.Field2 WHERE Table2.Field3='something' I have this error message ,,Syntax error in UPDATE statement,, Thanks for your help.
Top Bottom