You need to extract data from the system your predecessor created. you discover tables have been created according to the third
normal form. you find the needed data in three different tables. what SQL syntax allows you to garner this data?
a. union
b. join
c. Select
d. Having
a. union
b. join
c. Select
d. Having
1 answer:
Answer:
b. join
Explanation:
Correct answer:
Join: It allow join(paste) two tables by one or more commun columns
Example in the image attached
Bad answer:
Union: it only allow paste two tables with the same structure
select: it only allow get information from 1 table if not use join
having: it only allow get filtered information with a condition
You might be interested in
Using the knowledge of computational language in python it is possible to write a code that write (define) a public static method named countup, that takes one int argument and returns no value.
<h3>Writting the code:</h3><em>public class </em><em>Main</em>
<em>{</em>
<em>public static void main(</em><em>String</em><em>[] args) {</em>
<em>// testing the method </em><em>countDown </em><em>with values 5, 6, 1</em>
<em>countDown(5);</em>
<em>System.out.println();</em>
<em>countDown(6);</em>
<em>System.out.println();</em>
<em>countDown(2);</em>
<em>System.out.println();</em>
<em>}</em>
<em />
<em>public static void </em><em>countDown</em><em>(int num)</em>
<em>{</em>
<em>for (int i=1 ; i<=num ; i++) // for </em><em>loop </em><em>iterates from 1 to num</em>
<em>{</em>
<em>System.out.print(i+","); // prints num followed by comma ,</em>
<em>}</em>
<em>}</em>
<em>}</em>
See more about JAVA at brainly.com/question/12975450
#SPJ1
