Thursday, 15 May 2014

sql - How to define destination for an append query Microsoft Access -


I am currently trying to add two tables in MS Access. This is my SQL view of my query at this time:

  In the main table, select INSERT Table 1 from Insert, go to Table 1 on Table 2. University = Table 2. University;  

Where "university" is the only field name, where there are similarities between the two tables when I try and run the query, I get this error :

  query should contain at least one destination area.  

I have assumed that the code INSERT was defining the destination of my SQL, but apparently I am wrong. How can I specify my destination?

You must select something from your selection statement.

  Select the menu item, call 1, from the call 2 to the table 1 on the inner table, in the table 1. University = Table 2. University;  

No comments:

Post a Comment