>Oracle forms is a primitive tool. It's simple and easy. And Oracle PL-SQL better from Microsoft's. You don't have to learn complex inner outer join commands. Just do it:
>
>select a.name,b.salary from personal a,salaries b where (+) a.code=b.code
>
>You see. You just use (+) instead of inner/outer join keywords. It's more clear and easy. Oracle has a lot of better keywords from MS-SQL. But I have to accept that you cannot find an equivalent of MS-SQL's bookonline. Bookonline is excellent...
MS SQL Server supported similar ugly syntax for outer joins until SQL 2005. It actualy makes queries much less readable because it combines filter conditions and joins.
--sb--