Thank you, here it is :

View finalview
*UpdateType 1
*WhereType 3
*FetchMemo TRUE
*ShareConnection FALSE
*SendUpdates TRUE
*Prepared FALSE
*CompareMemo TRUE
*FetchAsNeeded FALSE
*UseMemoSize 255
*FetchSize 100
*MaxRecords -1
*Tables dbfinal!moveout, dbfinal!whymove, dbfinal!finaltable

*SQL

SELECT Moveout.idnr, Moveout.bldg_unit, Moveout.fname, Moveout.name, Moveout.fname2, Moveout.name2, Moveout.fname3, Moveout.name3, Moveout.move_in, Moveout.move_out, Moveout.lastrent, Moveout.deposit, Moveout.balance, Whymove.address, Whymove.city, Whymove.state, Whymove.zip, Finaltable.keys, Finaltable.secdep, Finaltable.petdep, Finaltable.payments, Finaltable.interest, Finaltable.otherc, Finaltable.otherc2, Finaltable.otherc3, Finaltable.otherc4, Whymove.rec_id AS wrecid, Whymove.idnr AS widnr, Finaltable.rec_id AS frecid, Finaltable.idnr AS fidnr
FROM dbfinal!moveout
INNER JOIN dbfinal!whymove
LEFT OUTER JOIN dbfinal!finaltable
ON Whymove.idnr = Finaltable.idnr
ON Moveout.idnr = Whymove.idnr
WHERE ALLTRIM(Moveout.bldg_unit) = ALLTRIM(THISFORM.Pgf.page1.txtBldgUnit.Value)
AND ALLTRIM(UPPER(Moveout.name)) = ALLTRIM(UPPER(THISFORM.Pgf.page1.txtName.Value))

*SourceType 1
*BatchUpdateCount1
*Comment
Field idnr
*KeyField TRUE
*Updatable TRUE
*UpdateName dbfinal!moveout.idnr
*DataType N(6)
Field bldg_unit
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!moveout.bldg_unit
*DataType C(9)
Field fname
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!moveout.fname
*DataType C(15)
Field name
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!moveout.name
*DataType C(20)
Field fname2
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!moveout.fname2
*DataType C(15)
Field name2
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!moveout.name2
*DataType C(20)
Field fname3
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!moveout.fname3
*DataType C(15)
Field name3
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!moveout.name3
*DataType C(20)
Field move_in
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!moveout.move_in
*DataType D
Field move_out
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!moveout.move_out
*DataType D
Field lastrent
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!moveout.lastrent
*DataType N(9,2)
Field deposit
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!moveout.deposit
*DataType N(9,2)
Field balance
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!moveout.balance
*DataType N(10,2)
Field address
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!whymove.address
*DataType C(40)
Field city
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!whymove.city
*DataType C(20)
Field state
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!whymove.state
*DataType C(2)
Field zip
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!whymove.zip
*DataType C(7)
Field keys
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!finaltable.keys
*DataType D
Field secdep
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!finaltable.secdep
*DataType N(9,2)
Field petdep
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!finaltable.petdep
*DataType N(9,2)
Field payments
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!finaltable.payments
*DataType N(9,2)
Field interest
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!finaltable.interest
*DataType N(9,2)
Field otherc
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!finaltable.otherc
*DataType N(9,2)
Field otherc2
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!finaltable.otherc2
*DataType N(9,2)
Field otherc3
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!finaltable.otherc3
*DataType N(9,2)
Field otherc4
*KeyField FALSE
*Updatable TRUE
*UpdateName dbfinal!finaltable.otherc4
*DataType N(9,2)
Field wrecid
*KeyField TRUE
*Updatable TRUE
*UpdateName dbfinal!whymove.rec_id
*DataType C(8)
Field widnr
*KeyField TRUE
*Updatable TRUE
*UpdateName dbfinal!whymove.idnr
*DataType N(6)
Field frecid
*KeyField TRUE
*Updatable TRUE
*UpdateName dbfinal!finaltable.rec_id
*DataType C(8)
Field fidnr
*KeyField TRUE
*Updatable TRUE
*UpdateName dbfinal!finaltable.idnr
*DataType N(6)