Loading Specfic Data

[#1]

Hey,

I know this will appear so basic but if I only want to load specific data what is the proper way to write the statement?

I want to load all the data for "produce" which is in the "department" field how do I write that?

thanks!

[arulsettu]

load

a,

b,

c

from table name where department = 'produce'

[sushil353]

Try:

Load * from tableName where department = 'produce';