Timeline for How do I write a left join query?

11 events

when toggle format	what		by	license	comment
S Jun 2, 2013 at 19:09	history	suggested	Neograph734	CC BY-SA 3.0	made the leftjoin stand alone, so it it is valid Drupal code.
Jun 2, 2013 at 19:04	review	Suggested edits
S Jun 2, 2013 at 19:09
May 21, 2013 at 8:18	comment	added	FLY		@Neograph734 I suggested an edit based on your comment.
May 21, 2013 at 8:17	review	Suggested edits
May 21, 2013 at 8:56
S Apr 29, 2013 at 14:31	history	suggested	General Redneck	CC BY-SA 3.0	Fixing issues with the code... leftJoin doesn't allow chaining.
Apr 29, 2013 at 13:34	review	Suggested edits
S Apr 29, 2013 at 14:31
Mar 18, 2013 at 16:33	comment	added	Neograph734		This won't work. Drupal joins can't be chained. So you'd go: `$terms = db_select(...)->fields(...); $terms->leftJoin(...); $terms->condition(...)->...`
Sep 20, 2012 at 16:03	comment	added	Johnathan Elmore		Does this work? When I try to do something identical to this I get an error that condition() is not a member function.
May 29, 2011 at 8:46	history	edited	avpaderno♦	CC BY-SA 3.0	added 110 characters in body
May 29, 2011 at 7:17	comment	added	enjoylife		how to retrieve the result? thank you
May 29, 2011 at 7:10	history	answered	Sivaji	CC BY-SA 3.0