CodingForums.com - View Single Post

Old Pedant · 07-13-2012, 07:04 PM

dla: I *SHOWED* you the error. Look at the word voltage in red in my last post. SQL Server does NOT KNOW which "voltage" you mean by that one. Put the table alias in front of it.

But ALSO read what I wrote about LEFT JOIN being converted to INNER JOIN by your other mistake.

07-13-2012, 07:04 PM	PM User \| #13
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,172 Thanks: 59 Thanked 3,995 Times in 3,964 Posts	dla: I SHOWED you the error. Look at the word voltage in red in my last post. SQL Server does NOT KNOW which "voltage" you mean by that one. Put the table alias in front of it. But ALSO read what I wrote about LEFT JOIN being converted to INNER JOIN by your other mistake. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.