LaFlame
20-08-2007 19:20:52
so i have 2 tables...i want to add a column(Bate) from tb2 to tb1...i dont want to update it, just add it from tb2 to tb1....so it would be Bate, bate, par, val, path....
i tried this query, but it didnt work out well...
select bate.tb2, bate.tb1, par.tb1, val.tb1, path.tb1
from tb1, tb2
tb1
bate
par
val
path
tb2
Bate
ID
customer