[dba-SQLServer] Newbie needs help with select statement

Because of Sql Server standards, try to stick to Joins made with the INNER /
LEFT / FULL / OUTER keywords (see books Online).  Joins made at the where
clause do work but may have sporadic results that are not consistent.


-Francisco
http://sqlthis.blogspot.com | Tsql and More...


On Sat, Jan 31, 2009 at 1:56 PM, jean-paul <jnatola at hotmail.com> wrote:

>
> So I read about 50 webpages and decided to try this statement
>
> SELECT *FROM contacts, contacts_organization_typesWHERE contacts.id =
> contacts_organization_types.id
>
> and still empty results
>
>
>          Jean-Paul Natola > Date: Sat, 31 Jan 2009 10:05:55 -0800> From:
> fhtapia at gmail.com> To: dba-sqlserver at databaseadvisors.com> Subject: Re:
> [dba-SQLServer] Newbie needs help with select statement> > Jean-Paul,> I
> guess I misunderstood you a bit on what you were trying to achieve.> let's
> change the terminology a little bit so that we're all talking the same>
> language,> > A field is also known as a column so that would be ID,
> First_name,> Last_name, the results are rows... so you are receiving 24 rows
> with the> fields ID, First_name, Last_name, email> > in order to know what
> to join by, can you do a select of the 2nd table and> let me know the field
> names?> > select * from contacts_organization_types> -Francisco>
> http://sqlthis.blogspot.com | Tsql and More...> > > On Sat, Jan 31, 2009
> at 8:54 AM, jean-paul <jnatola at hotmail.com> wrote:> > >> > the contacts
> table has 24 fields id first_name last_name etc.., I want> > every single
> record and field from that table.the contacts_org_types table> > has three
> fields id organization_type and internal, I want only the> >
> organization_type field from that table, so , I *believe* that i should see>
> > 25 fields in my result 24 from table 1 and 1 from table 2- thanks> >
> Jean-Paul Natola > From: markamatte at hotmail.com> To:> >
> dba-sqlserver at databaseadvisors.com> Date: Sat, 31 Jan 2009 12:49:06
> +0000>> > Subject: Re: [dba-SQLServer] Newbie needs help with select
> statement> > > 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.> > As long as I am
> 'assuming'...I think the scenario might be a> > translation table...and the
> first attemp produced a cartesian join(no joins)> > and listed each contact
> having every kind of cust_org_types...so the> > confusion might be what
> fields to join on.> > Francisco's Example modified:>> > > SELECT * FROM
> contacts AS ctcs> INNER JOIN contacts_organization_types AS> > cot ON
> ctcs.cust_org_types = cot.id> > I'm guessing there is a> > cust_org_types
> field in the contacts table...and there is a value that needs> > to be
> translated?> > If I am off target...please let me know.> > Thanks,> >>> >
> _________________________________________________________________> >
> Hotmail(R) goes where you go. On a PC, on the Web, on your phone.> >> >
> http://www.windowslive-hotmail.com/learnmore/versatility.aspx#mobile?ocid=TXT_TAGHM_WL_HM_versatility_121208>
> > _______________________________________________> > dba-SQLServer mailing
> list> > dba-SQLServer at databaseadvisors.com> >
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >
> http://www.databaseadvisors.com> >> >>
> _______________________________________________> dba-SQLServer mailing list>
> dba-SQLServer at databaseadvisors.com>
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver>
> http://www.databaseadvisors.com>
> _________________________________________________________________
> Windows Live™: E-mail. Chat. Share. Get more ways to connect.
>
> http://windowslive.com/howitworks?ocid=TXT_TAGLM_WL_t2_allup_howitworks_012009
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>