Hashemian Blog
Huh? What?
Friday, November 03, 2006
Politics of SQL Left Join and Right Join
 The other day I was helping a colleague with an SQL statement and I noticed he had a left join in his query. For those of you unfamiliar with SQL, it is a query language programmers use to access and manipulate data inside databases. Joins are used to cross-reference data between various database tables.
With the mid-term elections around the corner there is quite a bit of usage of words like right, left, liberal, and conservative around the nation, so seeing the left join in the query invoked thoughts of politics in my head. My colleague is a conservative, and I am firmly to the left of the center, but not quite off the cliff. We sometimes engage in political debates, and as all debates go have never convinced each other of the other person's persuasions.
Anyways, I scolded him for betraying his party by using a left join in his SQL statement. And then I thought to myself what a perfect way to resist the right-wing agenda.
So, no matter what your platform (as in your database platform), Oracle, SQL Server, MySQL, DB2, Sybase, or even Access, on November 7th boycott right joins and only use left joins. Then vote Democrat. You can do it. Right joins are useless anyways while left joins are so much more intuitive. They just make more sense.
Yeah, let's write a petition to ANSI and all database vendors and demand an end to the right join absurdity. Together we can send right join to the ash heap of query history. Obsolescence and deprecation is the right join's destiny.
democrat,republican,sql,joins,left join,right join,oracle,mysql,politics,conservative,liberal,vote <Politics of SQL Left Join and Right Join>
// posted by rh
|
Links
Technorati Profile
TMCnet.com
ARCHIVES
09/01/2003 - 10/01/200303/01/2004 - 04/01/200404/01/2004 - 05/01/200405/01/2004 - 06/01/200406/01/2004 - 07/01/200407/01/2004 - 08/01/200408/01/2004 - 09/01/200409/01/2004 - 10/01/200410/01/2004 - 11/01/200411/01/2004 - 12/01/200412/01/2004 - 01/01/200501/01/2005 - 02/01/200502/01/2005 - 03/01/200503/01/2005 - 04/01/200504/01/2005 - 05/01/200505/01/2005 - 06/01/200506/01/2005 - 07/01/200507/01/2005 - 08/01/200508/01/2005 - 09/01/200509/01/2005 - 10/01/200510/01/2005 - 11/01/200511/01/2005 - 12/01/200512/01/2005 - 01/01/200601/01/2006 - 02/01/200602/01/2006 - 03/01/200603/01/2006 - 04/01/200604/01/2006 - 05/01/200605/01/2006 - 06/01/200606/01/2006 - 07/01/200607/01/2006 - 08/01/200608/01/2006 - 09/01/200609/01/2006 - 10/01/200610/01/2006 - 11/01/200611/01/2006 - 12/01/200612/01/2006 - 01/01/200701/01/2007 - 02/01/200702/01/2007 - 03/01/200703/01/2007 - 04/01/200704/01/2007 - 05/01/2007
|
