>how to create outer join for remote view created on 2nd vfp Database.
>Rajesh

If you mean create a view in Database1 built on a remote view in (e.g.) Database2, the following should work...

to create it

OPEN DATA database2
OPEN DATA database1

** create remote view parameters, if any
vpRemoteParam = "SomeValue"

CREATE SQL VIEW lvMyView AS ;
  SELECT rvView1.field1, mytable.field2 ;
  FROM database1!mytable ;
  LEFT JOIN database2!rvView1 ;
  ON mytable.joinfield = rvView1.joinfield

to use it later..

OPEN DATABASE database2
OPEN DATABASE database1
vpRemoteParam = "SomeValue" && if needed
USE lvMyView