If they exist on the same instance no, use cross database queries

Like the following.

INSERT INTO DatabaseA.dbo.Mytable SELECT Col1, Col2 FROM DatabaseB.dbo.MyTable

If the database was on a different server, then yes a linked server would be needed.