i know that we can use JOIN with Tables in SQL
but my question is , can we use JOIN with declared tables inside stored
procedure like this
declare @MyTable table (
[Code] int )
insert into @MyTable
select * from Table2
select [Code2] from CodesTable Inner Join @MyTable On [Code] = CodesTable.[Code2] Can This Be DONE ?????