این رو امتحان کنید.



SELECT m.CodeMosh , m.Nam , 



	(SELECT COUNT( k.Code )

	

	FROM kharid k



	WHERE m.CodeMosh = k.CodeMosh) as TedadKharid

	

	

FROM moshtari m



GROUP BY TedadKharid