Linking Tables

Hot Topic

Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of '
The value could not be converted because of a potential loss of data in SSIS package
How to Backup remote Database
Auto Process Messages in Target Queue
error- microsoft ODBC sql server driver - timeout expired
regrouping hierarchies
Database 'msdb' cannot be opened
Error messages in event log - bucket table 5
Grant All function giving errors
Unable to send MAil Alert using DatabaseMail

SQL Server

Web App Failover problem
SQL Server 2005 Reporting Services on Windows Vista
Error opening VSA from Script component and Script Task
Directly printing Report from RS without previewing
visual studio running too slow
MDAC and SQL Server 2005
Executing an external process() in SQLCLR Project
Storing an array in an SSIS variable
Unable to connect to Analysis Services as a client
Which system tables hold SSIS pkg information

Linking Tables

my clients are in table1, all my repairs are in table2......If a client has a repair, how do i link the tables so that when i do

Select Repairs From Table2, i want it to pull the repairs along with the client name, but i really am stomped on how to do it any help

Answer this question

Linking Tables

David C Baldauff
Can create a view for the same. Basically an INNER JOIN on Clients and Repair table should be good.
avnerz
thanks that inner join worked perfectly!!
Linking Tables

Answer this question