>Hi all
>I have two free table :
>Table1 (ACode N(5,0), AName C(30))
>Table2 (ACode N(5,0), BName C(30))
>
>I want to have a view with ACode,AName,BName.
>Can i make this view without having any Database?
>If yes, HOW?
>
>Thanks

Views need a database. However you might create a temporary database to host the view. Or you might simply use SPT that doesn't need a database.
ie:

create database myTempDb
create sql view myView as ;
 Select  t1.Acode, t1.Aname, t2.Bname ;
 from table1 t1 ;
 inner join table2 t2 on t1.Acode == t2.Acode
* Code for view properties
* ...

SPT way:

lnHandle=Sqlstringconnect('Driver={Microsoft Visual FoxPro Driver};'+;
		'SourceDB=c:\myFolder;SourceType=DBF;Exclusive=No;')
SQLExec(m.lnHandle, ;
  "Select  t1.Acode, t1.Aname, t2.Bname "+;
  " from table1 t1 "+;
  " inner join table2 t2 on t1.Acode == t2.Acode", 'myView')
* Code to make it updatable
SQLDisconnect(m.lnHandle)
select myView
Browse

Cetin