Hi AnnuBhai,
Try like this....
SELECT vis_app_visitdetails.PVIS_ID ,
vis_app_visitors.VisName ,
vis_app_company.ComName ,
VD.VisitedCount Visited
FROM smarthawkattendance.vis_app_visitors
LEFT JOIN smarthawkattendance.vis_app_company ON (vis_app_visitors.companyID = vis_app_company.companyID)
LEFT JOIN (SELECT PVIS_ID, COUNT(PVIS_ID)VisitedCount FROM smarthawkattendance.vis_app_visitdetails) VD ON (VD.PVIS_ID=vis_app_visitors.PVIS_ID = )
WHERE (vis_app_visitdetails.dtVis_DateTime BETWEEN '2013-02-05 00:00:01' AND '2013-02-05 23:59:59' )
AND (vis_app_visitors.PVIS_ID=V0202130015 and vis_app_visitors.PVIS_ID=V0502130021);
Regards,
GVPrabu