|
|
|
ช่วยดู code การเขียนตาราง VIew ให้หน่อยครับ มัน err อะคับ ช่วยที่ครับ |
|
|
|
|
|
|
|
Code (SQL)
CREATE VIEW management
AS SELECT serial.srl_id, serial.srl_name, type.typ_name, brand.bnd_name,model.mod_name,pattern.pat_detail,setall.ip_address,
address.add_side,address.add_section,address.add_section,address.add_building,address.add_floor,setall.set_name,employee.emp_id,
employee.emp_name,employee.emp_rank,employee.emp_grad,employee.emp_tel,type.typ_id,brand.bnd_id,model.mod_id,pattern.pat_id,
setall.set_id,address.add_id,employee.emp_id
FROM serial,type,brand,model,pattern,setall, address,employee
WHERE serial.srl_id = type.typ_id and serial.srl_id = brand.bnd_id and serial.srl_id =model.mod_id and serial.srl_id = pattern.pat_id
serial.srl_id = setall.set_id and serial.srl_id = address.add_id and serial.srl_id = employee.emp_id ;
Tag : PHP, MySQL
|
|
|
|
|
|
Date :
2013-05-09 11:09:10 |
By :
romanticaood |
View :
664 |
Reply :
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Error อะไรครับ
|
|
|
|
|
Date :
2013-05-09 11:44:50 |
By :
mr.win |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ได้และครับ ขอบคุณครับ
|
|
|
|
|
Date :
2013-05-09 13:19:20 |
By :
romanticaood |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 00
|