[dba-SQLServer] Newbie needs help with select statement

didnt work with  the brackets [] either         Jean-Paul Natola > Date: Sat, 31 Jan 2009 08:48:34 -0800> From: fhtapia at gmail.com> To: dba-sqlserver at databaseadvisors.com> Subject: Re: [dba-SQLServer] Newbie needs help with select statement> > the join criteria I specified was:> ON ctcs.ID = cot.id> > so ID should match ID based off his example> > maybe add brakets around this field ie, ctcs.[ID] = cot.[ID]> > > -Francisco> http://sqlthis.blogspot.com | Tsql and More...> > > On Sat, Jan 31, 2009 at 4:49 AM, Mark A Matte <markamatte at hotmail.com>wrote:> > >> > I hate to make assumptions...but the subject says 'newbie'...and Francisco> > suggested the fields to join on...not Jean Paul.> >> > Jean Paul, what fields from each table are you trying to join on(the actual> > field names)?> >> > If the example below was used 'as is' and there is an 'ID' field in each> > table but its not the relationship between these two tables...won't give the> > results.
_________________________________________________________________
Windows Live™: E-mail. Chat. Share. Get more ways to connect. 
http://windowslive.com/howitworks?ocid=TXT_TAGLM_WL_t2_allup_howitworks_012009