作者sui623 (超尴尬...)
看板Database
标题Re: [SQL ] 不知道有没有这种写法...
时间Wed Dec 12 18:11:48 2007
我多加了AS才可以跑...不过还是谢谢你..
: A1.`id`=A2.`num`
: SELECT ... FROM `adderss_book` A1,
: (
: SELECT * FROM `phd_student`
: UNION ALL
: SELECT * FROM `ncu_ms_student`
: UNION ALL
: SELECT * FROM `ncu_phd_student`
: UNION ALL
: SELECT * FROM `ms_student`
: ) AS A2
^^
: WHERE ...
: : 请问这个要怎麽改才会文法正确..还是有什麽变通的办法..
: : SELECT A1.`id`,A1.`name`,A2.`chinese_name` ,A1.`jobs_type` ,A2.`email` ,
: : A1.`cellphone` FROM `address_book` A1,`phd_student` A2 `( OR
: : `ncu_ms_student` A2 OR `ncu_phd_student` A2 OR `ms_student` A2 ) WHERE
: : A1.`id`=A2.`num`
: SELECT ... FROM `adderss_book` A1,
: (
: SELECT * FROM `phd_student`
: UNION ALL
: SELECT * FROM `ncu_ms_student`
: UNION ALL
: SELECT * FROM `ncu_phd_student`
: UNION ALL
: SELECT * FROM `ms_student`
: ) A2
: WHERE ...
: 我猜你是要A2在这四个表中去找
: 所以用个子查询把四个表一次抓回来 令为A2
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.114.85.82