Ted Roche wrote on 2015-05-18: > On Mon, May 18, 2015 at 3:05 PM, Tracy Pearson <tr...@powerchurch.com> wrote: > > I believe by default the FROM Led, Cat is an implicit LEFT JOIN. You'll get > all the records from LED, and only matching records from CAT. If the second > iCat_Id was pulling from Cat, it would probably be blank the same time > cCategory is. > > > I don't think so. I believe this should give the exact same result as: > SELECT led.iCat_Id, ddate, Led.iCat_Id, cCategory; > FROM Led JOIN Cat ON Cat.iCat_Id = Led.iCat_Id > But, Joe, try it that way to see if it makes a difference. > > You probably want to change the 3rd column to say Cat.iCat_Id, don't you? > > --- > Ted Roche & Associates, LLC > http://www.tedroche.com
Ted, Thank you Ted. I stand corrected. https://msdn.microsoft.com/en-US/library/f4saeycb%28v=vs.80%29.aspx#fogrfjoi nconditionsfortablesqueriesandviewsanchor5 Tracy Pearson PowerChurch Software _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000f01d091a3$d038bb20$70aa3160$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.