Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Steve2106
Posting Yak Master
183 Posts |
 Posted - 2007-07-05 : 06:55:49
|
| Hi Guys,I'm a beginner so please forgive me if this is a poor question.I need to show data from two tables. The tables are called HeaderText & ParaText.For all the records in HeaderText I need to show the Associated ParaText Data. I.EPerson/s accountable for safety: (from HeaderText) Dave Stevens (from Paratext) Elain Davis (from Paratext) George Challis (from Paratext)Person/s in charge of security: (from HeaderText) Tony Blunt (from ParaText) Thomas Saga (from ParaText)etc etcHow would I do that?Thanks for your help.Best Regards,Steve |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-05 : 12:14:42
|
| Use join or union, depends on table schema. |
 |
|
|
|
|
|
Data from 2 tables