Re: [SQL ] 不知道有沒有這種寫法...
我多加了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
討論串 (同標題文章)