SELECT *, [1103_old_system].*, [1103_old_system].dbo.tb_bill_pre.Col001 AS Expr1, [1103_old_system].dbo.tb_bill_pre.Col002 AS Expr2,
[1103_old_system].dbo.tb_bill_pre.Col003 AS Expr3, [1103_old_system].dbo.tb_bill_pre.Col004 AS Expr4,
[1103_old_system].dbo.tb_bill_pre.Col005 AS Expr5, [1103_old_system].dbo.tb_bill_pre.Col006 AS Expr6
FROM tb_ticket_part1 INNER JOIN
tb_ticket_part1_subject ON tb_ticket_part1.id_ticket = tb_ticket_part1_subject.id_ticket INNER JOIN
tb_subject_fault ON tb_ticket_part1_subject.id_sub = tb_subject_fault.id_subject INNER JOIN
tb_province ON tb_ticket_part1.province = tb_province.id INNER JOIN
[1103_old_system].dbo.tb_bill_pre ON tb_ticket_part1.number = [1103_old_system].dbo.tb_bill_pre.Col001
WHERE (tb_ticket_part1.ticket_status = 'open') AND (tb_province.id_opmc = '5')
คือว่าอยากจะ convert field Col001 ให้เป็น Integer ครับ จะต้องทำอย่างไรครับ ขอคำชี้แนะจากพี่ๆหน่อยครับ ขอบคุณครับ
Load balance : Server 05
