What states is Tesco located in? | do you mean the address id or the address details? | The address details.
SELECT T3.address_details FROM Suppliers AS T1 JOIN supplier_addresses AS T2 ON T1.supplier_id   =   T2.supplier_id JOIN addresses AS T3 ON T2.address_id   =   T3.address_id where T1.supplier_name  =  'Tesco'
states Tesco is located in refers to address_details; need to join Suppliers table with supplier_addresses and addresses tables; supplier_name = 'Tesco';