Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

relational database

/in /by

Question

Suppose that there are two tables, T1 and T2, in a relational database. T2 has

an attribute A1 served as a foreign key referencing an attribute B1 in T1. Which one of the following statements is the right way to join two tables?

A. SELECT T1.*, T2.* FROM T1 and T2 by T2.A1=T1.B1

B. SELECT T1.*, T2.* FROM T1, T2 on T2.A1=T1.B1

C. SELECT T1.*, T2.* FROM T1 JOIN T2 on T2.A1=T1.B1

D. SELECT T1.*, T2.* FROM T1 JOIN T2

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"