[dba-SQLServer] Newbie needs help with select statement

you flew way over my head on that one-

in the db all contacts have a value in the org type field from the second table


I want ALL the contacts from the contacts table
and Im NOT looking for a specific criteria from the contacts_org_tpes I just want  it to return the value

 

 

 

 

 

 

 

 

 

 

Jean-Paul Natola

 




> Date: Fri, 30 Jan 2009 21:25:49 -0800
> From: fhtapia at gmail.com
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Newbie needs help with select statement
> 
> Jean Paul,
>   You'll want to define your where criteria... that is:
> 
> SELECT * FROM contacts AS ctc WHERE NAME = 'Criteria'
> 
> this way the results are what you expect
> 
> To join two tables you will want to associate the corresponding fields
> 
> Such as:
> 
> SELECT * FROM contacts AS ctcs
> INNER JOIN contacts_organization_types AS cot ON ctcs.ID = cot.id
>  WHERE ctcs.name = 'Criteria'
> 
> some interesting  things are happening here... first I have used a table
> alias that's where you see the table name contacts followed by the keyword
> AS then an abbreviation of my liking (no reserved words) such as ctcs
> 
> so I 'm telling the engine that I will from that point on substitute the use
> of ctcs whenever it expects to see an explicit reference for the table name
> contacts.  Also if you take a look at the criteria, you'll notice that I
> have a field name in there the name I took from your example but it should
> be any valid name in your table that you want to search against... saying
> WHERE 1 is a true statement, but does not reflect the case of WHERE id = 1,
> so you may want to revise your select statement.
> 
> 
> 
> -Francisco
> http://sqlthis.blogspot.com | Tsql and More...
> 
> 
> On Fri, Jan 30, 2009 at 8:58 PM, jean-paul <jnatola at hotmail.com> wrote:
> 
> >
> > Hi all,
> >
> > So I was attempting to for the first time to get data using the select
> > statment
> >
> > here was my first syntax
> > SELECT * FROM `contacts` WHERE 1
> >
> > it returned all the records (as I wanted) 9050 records
> > contact name  address emaill etcc..
> > now there is another table called contacts_organization_types
> > I wanted the  corresponding output to come out in the same query
> >
> > so i tried this
> > SELECT * FROM `contacts`,`contacts_organization_types` WHERE 1
> >
> > now i got the same results as above-  but instead of it  adding the field
> > to the list it returned each record from the contacts with every single
> > cust_org_types for example
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > first statement results;
> >
> > id first name last name      email
> > 1  jp            natola
> >
> >
> > second statment results;
> >
> >
> >
> > id first name last name      email   organaization type
> > 1  jp            natola                    NGO
> >
> >
> > 1  jp            natola                    MED
> >
> > 1  jp            natola                    Donor
> >
> > 1  jp            natola                    Education
> >
> > 1  jp            natola                    Media
> >
> > How do i modify the statement to just give me the record with the actual
> > value that is in the contacts record
> >
> > 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™ Hotmail®…more than just e-mail. 
http://windowslive.com/howitworks?ocid=TXT_TAGLM_WL_t2_hm_justgotbetter_howitworks_012009