How about Lidl?
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  =  'Lidl'
address details for a specific supplier (Lidl) involves joining Suppliers, supplier_addresses, and addresses tables based on supplier_id and address_id;