i want to join two table where project number is equal to project no with concantate number 999.
for eg.
select * from proj as a
inner join Prsp as b
on bposid = aposid+'999'
into table ittab where invl=inventoryno
any suggestion.