>Hi all
>I have two table :
>
>Table1 ( acode n(2,0) , aname c(10))
>Table2 ( acode n(2,0) , bname c(10))
>
>i want to have a grid with three column : acode,aname,bname
>i dont want to create and use from CURSOR. i want to use from table1,table2 fields directly.
>can i do this? if yes, how?
>Thanks
You can set a relation between the tables to do this, but I prefer using a view or cursor. Why don't you want to use a cursor?
IAC, what is the relationship between these two tables? Is it always a 1-to-1 relationship? Is it a 1-to-many with Table1 being the parent? The answer determines the correct way to setup your relation.