small problem

[victorashi]

hello , i have here a procedure wich gives me all data from one employee, but the result table gives me more than 4 times the ID column , how should i write it so that it will bring me only one time this column ?

CREATE PROCEDURE EmployeeDetails
@nr int
AS
BEGIN
SELECT * FROM table1
INNER JOIN viza ON table1.id = viza.id
INNER JOIN work_prmit ON table1.id = work_permit.id
INNER JOIN pass ON table1.id = pass.id
LEFT OUTER JOIN married ON table1.id = married.id LEFT OUTER JOIN divorced ON table1.id = divorced.id
LEFT OUTER JOIN wife_dead ON table1.id = wife_dead.id
where
table1.id = @nr
END
GO

 

[chrissie1]

replace the * with the columns you want.

Christiaan Baes
Belgium

"My new site" - Me

 

[victorashi]

thanks a bunch