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? a) ambiguous column error b) cross-join but no error message c) general syntax error d) no errors —results
OR