Could you please correct me? Thanks

SELECT Customer.dbo.Store.Store, Customer.dbo.Store.names, Customer.dbo.Store.address,Customer.dbo.Store.epos group,
Customer.dbo.Store.scandate, Customer.dbo.Store.Vendor , --CONVERT(CHAR(8),Customer.dbo.Store.lastupdate,3) as 'Last UpDate',
Customer.dbo.Store.refusal, eposdata.dbo.ProcStatusTY.ProcStatus
FROM eposdata.dbo.ProcStatusTY, Customer.dbo.Store
WHERE eposdata.dbo.ProcStatusTY.WeekNumber = 24
--AND Customer.dbo.Store.Vendor = 'leaders'
AND Customer.dbo.Store.Vendor != 'cbe' , 'leaders', 'merit'
ORDER BY eposdata.dbo.ProcStatusTY.ProcStatus desc

Solution::
first of all there should be common column for join in both table like(Customer.dbo.Store.ID=eposdata.dbo.ProcStatus TY.ID)
than
use this--> Customer.dbo.Store.Vendor in( 'cbe' , 'leaders', 'merit')<-- in place of ..
Customer.dbo.Store.Vendor != 'cbe' , 'leaders', 'merit'

Piyush, thanks for that. Still not working