OT: SqlSever 2000 question

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Wed, 28 Nov 2001 07:46:25 -0800
Message-ID: <F001.003CF095.20011128073036@fatcity.com>

Hi All,

Sorry for OT but I am very new(few hours) to sql server and need help with constructing a query.

I have 2 tables

Table1     Table2
id             id
name,       county

state

There is 1 -> many from table1 to table2 I want to retrieve each record in table1 along with all the counties in table2 for that ID in one record
For ex. 1,SmithJ,TN,county1 | county2 | county3 | countyN

Any ideas,

Thanks
Rick
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 28 2001 - 09:46:25 CST