List:General Discussion« Previous MessageNext Message »
From:Caroline Guénette Date:May 27 2003 11:53am
Subject:RE: About LEFT and RIGHT join (another question)
View as plain text  
The Query interface of SQL Server Enterprise


-----Message d'origine-----
De : electroteque [mailto:daniel@stripped]
Envoyé : 26-05-2003 18:38
À : mysql@stripped
Objet : RE: About LEFT and RIGHT join (another question)


and what tool is this ?



(sorry for language mistakes. It's not my mother tongue...)

I use a Query tools to create a SELECT statement. When I put something
similar to Mike`s anwser (WHERE table1.key = table2.key ...), the Query
tools change it for a LEFT JOIN. Why? Is it more efficient with a JOIN close
than a WHERE close?

Thanks!
Thread
About LEFT and RIGHT join (another question)Caroline Guénette26 May
RE: About LEFT and RIGHT join (another question)Mike Hillyer26 May
  • RE: About LEFT and RIGHT join (another question)electroteque26 May
RE: About LEFT and RIGHT join (another question)Caroline Guénette27 May