[問題] database view跟table的問題
<<<Database>>>
create view時
是用table來create的
那請問可以用幾個view來create新的一個view嗎?
就像:
create view viewNEW as select
viewAAA.entity_id, viewAAA.time_id, viewAAA.value as viewAAA,
viewBBB.entity_id, viewBBB.time_id, viewBBB.value as viewBBB,
viewCCC.entity_id,viewCCC.time_id,viewCCC.value as viewCCC,
from viewBBB, viewAAA, viewCCC
where viewAAA.entity_id = viewCCC.entity_id,
viewCCC.entity_id = viewBBB.entity_id
--
◤ ◥ ═╩╛══╮ ╖╓ ╭══╯ ╭╦ ═ ║
> < ═ ══║ ╔╬╬╗ ╭═╮ ║ ║╠╦╛╒╦╛═╬═
╰ ╰╯ ╯ ═ ╔╗║ ╠╬╬╣ ╠═╣║║ ║╯╠╛╭╣ ║
◣ ◢ ╔╗ ╚╝║ ║║║║ ╠═╯ ║ ║ ╠╛╯╠╮ ║
││ ╚╝ ╰╝ ╚╩╩╝ ╯口 ╰╜ ╰ ╰ ╯ ═╩═
顧問:eggbin ptt社板:MelodyLyric
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.112.91.5