| List: | General Discussion | « Previous MessageNext Message » | |
| From: | (Hal | Date: | April 26 2011 5:05pm |
| Subject: | Re: LEFT JOIN and WHERE: identical or not and what is better?, etc. | ||
| View as plain text | |||
>>>> 2011/04/26 17:55 +0300, Andre Polykanine >>>>
Aha. So, I should write
SELECT `Blogs`.* INNER JOIN `Users` ON `Users`.`Id`=`Blogs`.`UserId`
instead of my original WHERE clause?
Thanks!
<<<<<<<<
I think so.
| Thread | ||
|---|---|---|
| • LEFT JOIN and WHERE: identical or not and what is better? | Andre Polykanine | 25 Apr |
| • Re: LEFT JOIN and WHERE: identical or not and what is better? | Mitchell Maltenfort | 25 Apr |
| • Re: LEFT JOIN and WHERE: identical or not and what is better? | joao | 25 Apr |
| • Re: LEFT JOIN and WHERE: identical or not and what is better? | Johnny Withers | 25 Apr |
| • Re: LEFT JOIN and WHERE: identical or not and what is better? | Joerg Bruehe | 25 Apr |
| • Re: LEFT JOIN and WHERE: identical or not and what is better?,etc. | hsv | 26 Apr |
| • Re: LEFT JOIN and WHERE: identical or not and what is better?, etc. | Suresh Kuna | 26 Apr |
| • Re: LEFT JOIN and WHERE: identical or not and what is better?, etc. | Andre Polykanine | 26 Apr |
| • Re: LEFT JOIN and WHERE: identical or not and what is better?,etc. | hsv | 27 Apr |