>>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


Thank you