rating in website

this is my furniture_ch table that save users information

1-furniture_ch

and this is my furniture_p table.when users insert their product,products information save in this table

2-furniture_p

now i want in my page shows users information that insert their product recently sort by date 

at first i run this query in sql

SELECT  address   ,tell,name
    ,(Select COUNT(behcode) from furniture_p where behcode= furniture_ch.behcode) as [count]
from furniture_ch order by furniture_p.date desc

this error occur:

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "furniture_p.date" could not be bound.

after that i wrote your store proc in sql when run occured this error:

Msg 209, Level 16, State 1, Procedure GetProducts, Line 5
Ambiguous column name 'id'.
Msg 209, Level 16, State 1, Procedure GetProducts, Line 5
Ambiguous column name 'name'.
Msg 209, Level 16, State 1, Procedure GetProducts, Line 5
Ambiguous column name 'behcode'.

now what can i do?

When I have given you complete stored proc with all code I am amazed why you are not using it

hi

 i used it i told in my last replay  i wote your store proc but there was error:

Msg 209, Level 16, State 1, Procedure GetProducts, Line 5
Ambiguous column name 'id'.
Msg 209, Level 16, State 1, Procedure GetProducts, Line 5
Ambiguous column name 'name'.
Msg 209, Level 16, State 1, Procedure GetProducts, Line 5
Ambiguous column name 'behcode'.

i have all of this column in my database i dont know why this error occur?

You just need to add table name to solve this error

CREATE PROCEDURE [dbo].[GetProducts] @F_Code VARCHAR(100)AS
BEGIN
SELECT  furniture_p.id, furniture_p.name, [address]   ,tell,name, count(furniture_p.behcode) as [count] 
FROM furniture_ch, furniture_p 
WHERE F_code =@F_CodeORDER BY furniture_p.date desc END

hi 

thanks for your answer i did it  but again  occur  error:

Msg 8120, Level 16, State 1, Procedure GetProducts, Line 7
Column 'furniture_ch.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.