Suppose you have three tables: Orders: PK order num, FK customer num Customer: PK customer num, FK rep_num Rep: PK rep num And you tried to run the following SQL query: SELECT order_num, rep_num FROM …
Suppose you have three tables: Orders: PK order num, FK customer num Customer: PK customer num, FK rep_num Rep: PK rep num And you tried to run the following SQL query: SELECT order_num, rep_num FROM orders, rep; What would happen? ambiguous column error cross-join but no error message c) d) general syntax error no errors -results ok
OR