Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT users.username, companies.company, stores.store, stores.address, stores.city, stores.state, stores.zip
- FROM users
- LEFT JOIN stores
- ON users.store_id = stores.id
- LEFT JOIN companies
- ON companies.id = stores.company_id
- WHERE companies.id = 1
- ORDER BY stores.store;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement