Loading table with limited value selection of data (datafield flag set to 1)

[#1]

Hi,

I would like to load one of my tables (.qvd)  -  with only the values that have a flag,  set as 1,  in datafield "ServicePersonelFlag".

1.) How do I write the "load" statement...

     ' Is the "     where (ServicePersonelFlag) = 1    ".. after the

Table:

Load

or before the

From

(qvd);

2.) If this is not possible in QV - how do I go about creating and using this limited-value table in my document?

     A. Do I create a new table with only the selected values and then drop the old/original table ?

Thanks in advance

BR

Kriss

[#2]

I'm not sure to understand..

Table:

Load

.....

From

myqvd (qvd)

where ServicePersonelFlag = 1;