rating in website

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_Code
GROUP BY furniture_p.id, furniture_p.name, [address]  ,tell,name, cfurniture_p.behcode
ORDER BY furniture_p.date desc 
END

hi  thanks

it worked but The result was not what I had expected

this is furniture_ch table

furniture_p  Table

The result is that I am expected

all user insert product in same date but time is different and user with behcode=4444 insert product recently so it should shows above result but when i run site show this result

it shows all user with f_code=1 that are in furniture_ch 6 time

why?

there isnt  user with cehcode=5555 in furniture_p table but in result shows this user 

In the query I gave you there's no beh_code column so how can you get that in result?

it is behcode not beh_code and in query was behcode

SELECT  furniture_p.id, furniture_p.name, [address]   ,tell,name, count(furniture_p.behcode) as [count]

Still it should display count but in your case it is display actual behcode How?