Do we have table aliases concept in Baan IV.
I am getting errors if I write one SQL stmt with aliases.

rgds,
Jack

Yes, Aliases are possible in baan IV. But you can't use aliases in SQL Queries, you can use aliases in the SQL statements in the program scripts.
e.g.
select itm001.*
from tiitm001 itm001