I am trying to load only data where the following criteria is met:
Where[Prem Category Description]='SINGLES' AND [MI Sub Status Type]='CA'
Where do I put this statement in the load script? I am having trouble getting it to work.
After the from or resident table
Where [Prem Category Description] = 'SINGLES' and [MI Sub Status Type] = 'CA';
Retrieving data ...