Convert › F007
Field Interview Log
CJIWave 2Dataset query (SQL Server)
SELECT f.fi_id, f.fi_date, f.beat, f.reason FROM field_interview f WHERE f.agency_id = @Agency AND f.fi_date BETWEEN @DateFrom AND @DateTo
SELECT f.fi_id, f.fi_date, f.beat, f.reason FROM field_interview f WHERE f.agency_id = @Agency AND f.fi_date BETWEEN @DateFrom AND @DateTo