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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 sub queries

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-04 : 00:37:10
anand writes "say i have a table with fields
emp no ,sal
and another table with fields
emp no ,emp name

how do i procedure which displays emp name and sal fro all employees

pls check ur query with muliple records "

Nazim
A custom title

1408 Posts

Posted - 2002-02-04 : 00:41:43
Check for Joins in BooksOnline.

select e1.empname,e.sal from employee e
inner join employeedetails e1
on e.empno=e1.empno

HTH

--------------------------------------------------------------
Dont Tell God how big your Problem is , Tell the Problem how Big your God is
Go to Top of Page
   

- Advertisement -