you should have looked up syntax for INNER JOIN in books online.
it should be
select * from dbo.CM_CalculatedRVUs c
INNER JOIN dbo.DBMSBARBTXNLIPAY d
ON d.inv_num = c.inv_num
where <c|d>.provider like'Cashie%'
I dunno which table provider column comes from so make sure you put correct alias there
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Inner join
Posted - 05/30/2012 : 15:45:48
