QVD JOIN TABLE

[#1]

Hello,

Quick question.  Can QVD file be join with a table with a join clause?

Your help is appreciated!

[#2]

Trying to do something like this, but it is feasible?

FROM (qvd) a join (select distinct pos from dbo.Mapping with(nolock)) b

on a.pos=b.pos

[kaushiknsolanki]

Hi,

  Its very simple. Try following.

  Select Distinct pos

   from dbo.mapping;

  join

  Load abc,pos

  from xyz.qvd (qvd);

  Make sure that joining field have same name in both the table.

Regards,

Kaushik Solanki