Zend Preparation | PHP Quiz (Learning Mode)

Database and SQL Learning Mode

Qusetions Index 58/75

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75

I have information about customers stored in a table. each row has an account_id that is a foreign key to a table called accounts. how can you select the postcode column from the address table for a customer with ID 123?

SELECT `postcode` FROM `accounts` Where customer_id = 123;

SELECT `postcode` FROM `accounts` AS `acc` JOIN `customers` as `cust` On `cust.id` = `acc.id` Where `c`.id = 123

SELECT `postcode` FROM `accounts` AS `a` JOIN `customers` as `c` ON `c.account_id` = `a`.`id` Where `c`.id = 123

SELECT `postcode` FROM `accounts` AS `a` FULL OUTER JOIN `customers` as `c` On `c.id` = `a.id` Where `c`.id = 123