السلام عليكم.....................
ايه الخطأ فى الكود ده
@prisoner int
AS
SELECT * FROM prisoners INNER JOIN
prisoner_offences ON prisoners.prisoner_id = prisoner_offences.prisoner_id INNER JOIN
offences ON prisoner_offences.offence_id = offences.offence_id INNER JOIN
prisoner_visitors ON prisoners.prisoner_id = prisoner_visitors.prisoner_id
where prisoner_id=@prisoner
CREATE PROCEDURE search_prisoner
كل مرة تظهرلى رسالة الخطأ دى......
Server: Msg 209, Level 16, State 1, Procedure search_prisoner, Line 4
Ambiguous column name 'prisoner_id'.
ارجو المساعده..............