search

ubceats / foodfoodfood

🍕 UBCEats: A web portal for food items at UBC
http://www.ubceats.ca
3 stars 0 forks source link

List all venues/locations #3

Closed falkirks closed 6 years ago

falkirks commented 6 years ago

SELECT * FROM brand WHERE name LIKE '%Starbucks%';

falkirks commented 6 years ago 
SELECT b.name as brandName, l.name AS locationName FROM brand b, locations l
WHERE b.name LIKE '%Starbucks%' AND l.name LIKE '%Bookstore%';