var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: concatenate 2 fields and compare with third one
Can u tell me how do i concatenate fields
table1 : address_bk
Area_code char 3
phone char 7
table2 : phone
tel_no char 10
I want to concatenate both the fields in table1 , compare the results with table2 tel_no field and delete records from 1st table which are present in 2nd table...!
I use VB 6.0 as front end and SQL 7.0 as backend..!
delete from address_bk
where Area_code+phone in
(select tel_no from phone)