Create sql view "V_CUSTOMERHAULER" as ; select customerhauler.haulerid, customerhauler.customerid, customerhauler.sent2host, ; customerhauler.sent2interface, hauler.haulername ; from dbf!customerhauler ; left join dbf!hauler ; on customerhauler.haulerid = hauler.haulerid ; where customerhauler.customerid = l_custIf I strip the code down to a simple select statement and run it, it will select 8 records (correct). If I use this as is, I get 0 records and when I try to insert a record (when setup to be writable), I get the message "cannot insert an empty row into the base table"