Some times we need only a single field from a particular table while creating a report.Which sometimes has no relationship with others.To do this So many peoples are importing table and use a one field. Crystal Reports 9.0 onwards give us a facility called command which return the fields as you have specified in the command query.
To do this go to the database expert and select add command this will open a query window there and put the simple query and it will return fields you have specified in the query analyser.
It’s very simple.Happy Programming….