sql server 2005 - return single row when 2 records in right table

Posted by Peanut on Stack Overflow See other posts from Stack Overflow or by Peanut
Published on 2010-05-06T06:26:35Z Indexed on 2010/05/06 6:38 UTC
Read the original article Hit count: 278

Filed under:

sql-server-2005

|

tables

Hi, I have two related sql server tables ... TableA and TableB.

***TableA - Columns***
TableA_ID     INT
VALUE         VARCHAR(100)

***TableB - Columns***
TableB_ID     INT
TableA_ID     INT
VALUE         VARCHAR(100)

For every single record in TableA there are always 2 records in TableB. Therefore TableA has a one-to-many relationship with TableB.

How could I write a single sql statement to join these tables and return a single row for each row in TableA that includes:

a column for the VALUE column in the first related row in table B
a column for the VALUE column in the second related row in table B?

Thanks.

© Stack Overflow or respective owner

Related posts about sql-server-2005

[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4

as seen on SQL Authority - Search for 'SQL Authority'
If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL Server 2005 SP4. There are many… >>> More
SQL Server 2005 - Syncing development/production databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server. My main concern is deploying schema + data updates to developer machines from the "master" development… >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More

Related posts about tables

javascript to print all tables and individual tables

as seen on Stack Overflow - Search for 'Stack Overflow'
I am retrieving values from a database and displaying it a table using php. Each table is stored inside a div tag. <div id="print"> table content 1 </div> <div id="print"> table content 2 </div> .................. Can some one please suggest a javascript where i can get… >>> More
retrieve data from multiple tables referencing some tables in mysql

as seen on Stack Overflow - Search for 'Stack Overflow'
i have 10 tables have innoDB engine 1. one is state_table which attributes are state_id and state_name 2. another table city_table which attributes are city_id and city_name 3. one more table permit_table which attribute is p_id above city_id,state_id and permit_id is references to rest of 7… >>> More
Microsoft SQL Server 2005 Inserting into tables from child procedure which returned multiple tables

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a child procedure which returns more than table. child: PROCEDURE KevinGetTwoTables AS BEGIN SELECT 'ABC' Alpha, '123' Numeric SELECT 'BBB' Alpha, '123' Numeric1, '555' Numeric2 END example: PROCEDURE KevinTesting AS BEGIN DECLARE @Table1 TABLE ( Alpha varchar(50)… >>> More
retrive data from multiple tables referencing some tables in mysql

as seen on Stack Overflow - Search for 'Stack Overflow'
i have 10 tables have innoDB engine 1. one is state_table which attributes are state_id and state_name 2. another table city_table which attributes are city_id and city_name 3. one more table permit_table which attribute is p_id above city_id,state_id and permit_id is references to rest of 7… >>> More
Chained Hash Tables vs. Open-Addressed Hash Tables

as seen on Stack Overflow - Search for 'Stack Overflow'
Can somebody explain the main differences between (advantages / disadvantages) the two implementations? For a library, what implementation is recommended? >>> More