Plz Help!! I M Trying To Describe Question More Clearly

hi @ll...

Plz Plz help me out.!!!!!!!!

my query is that in my database i've a table say Tb1 and another table called Tb2.

in TB1 there is a field called companyID (the data is for e.g "001")

similarly in TB2 there is a filed called productID (the data is for example "01")

now how can i create a field in another table say TB3 with a field called UserID and the data should be like the companyID from TB1 + productID from Tb2. The data should come like this for example " 001-01 ".