SELECT T3.Shop_Name ,  T2.Carrier FROM stock AS T1 JOIN device AS T2 ON T1.Device_ID  =  T2.Device_ID JOIN shop AS T3 ON T1.Shop_ID  =  T3.Shop_ID
What are the names of device shops, and what are the carriers that they carry devices in stock for?
SELECT T3.Shop_Name , T2.Carrier FROM stock AS T1 JOIN device AS T2 ON T1.Device_ID = T2.Device_ID JOIN shop AS T3 ON T1.Shop_ID = T3.Shop_ID
select t3 . shop_name , t2 . carrier from stock as t1 join device as t2 on t1 . device_id = t2 . device_id join shop as t3 on t1 . shop_id = t3 . shop_id
What are the names of device shops , and what are the carriers that they carry devices in stock for ?