Posted by: scoopseven 17 years, 7 months ago
select a.*, ba.column1, bb.column1 from tablea a join tableb ba on a.column1 = ba.column1 and ba.column2 = 'string' join tableb bb on a.column1 = bb.column1 and bb.column2 = 'string' and a.column2 = bb.column3 where a.column3 = 'string' A couple of interesting things about this query. We're matching up 1 row in table a with 2 rows in table b by aliasing table b in two different ways. We're also using the "and" statement in our join, which is a neat trick. Share on Twitter Share on Facebook
Recent Tweets
-
@mashable
@Pete Cashmore
How unequal is wealth in the U.S.? @Charlie_White found this viral video that will astonish you: http://t.co/tgTKMoljnW11 years, 2 months ago -
@scoopseven
@Mark Kecko
"That pizza was great, but probably fattening as tarnation." @innerpeaceLMT @ccchiodo11 years, 2 months ago -
@scoopseven
@Mark Kecko
@MattioV You know it's bad when you're volunteering yourself for busy work. "I have some import statements to clean up, take me a few days."11 years, 2 months ago
Recent Posts
- Django: Unknown command: 'test'
- Granola
- Export Zinna - Import Mezzanine
- Apache Enable Directory Browsing (Indexes) in Arch Linux
- Python/Django Tips n' Tricks Cheatsheet
Archive
2013
2012
2011
2010
- December (1)
2009
2008
2007
2006
Categories
- Apache (5)
- Apple (2)
- ColdFusion (23)
- Database (3)
- Django (20)
- DNS (1)
- IIS (5)
- jQuery (1)
- Linux (13)
- Mac (1)
- MediaPost (14)
- MySQL (15)
- PHP (1)
- Python (10)
- Recipes (1)
- Sphinx (2)
- Tools (2)
- Windows (1)
- WordPress (4)
Authors
- scoopseven (81)