Skip to Content
0
Former Member
Dec 05, 2008 at 02:44 AM

inner join condition help

37 Views

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.