4 Comments on “Which command should you use in a query?”

1. Peter Smith says:

   February 9, 2016 at 5:39 pm

   C. Join

   
   
   
   2

   
   
   
   0
2. Pawan Chhangani says:

   May 22, 2016 at 9:35 am

   C join is correct answer accroding to given question

   
   
   
   1

   
   
   
   0
3. Tony says:

   June 3, 2017 at 8:35 am

   I would also say join, it is not asking for the data to be displayed from both tables, just that the tables have field/key that exists in both.

   
   
   
   0

   
   
   
   0
4. avalon333 says:

   November 12, 2018 at 9:32 am

   [The UNION clause allows you to combine the results of two or more queries into a resulting
   single set that includes all the rows belonging to the query in that union. The UNION clause is
   entirely different from the JOIN statements, which combine columns from two different tables.
   You must remember a couple of basic rules when combining the results of two queries via the UNION clause:

   So, C, Join

   
   
   
   0

   
   
   
   0