loading required data

[#1]

hi all,

I have 7 fields in my table and one of the field is client_id. I have 10 clients.

i want to load only data from all 7 fields of particular 5 clients.

anyone help to get it.

Thanks,

Pramod

[maxgro]

load

     *

from

     yourtable

where

     match(client_id, 'firstclientvalue', 'secondclientvalue')     // add other 3 values, maybe remove quote

[Anonymous]

Use "where" clause:

SELECT

client_id,

...

field7

FROM Table

WHERE client_id <meets some condition, or simply enumerated>

[jsanchezh · Accepted solution]

You can add the WHERE clause after the FROM clause on the script

Load * fields

From [directory]

Where client_id='name_client1' and client_id='name_client2' and client_id='name_client3'...

[maxgro]

I think or

where .... or ..... or .....

[Anonymous]

Certainly it is "or".  In this case, "and" will return no records at all.

And, if enumerate the values, it is cleaner with match().

[jsanchezh]

yes, that's right I made a mistake while writing it down (OR shall be the correct option)