Data view cannot display data

cctvgun

Hello everyone, established a view, the code is as follows:
CREATE VIEW "(Untitled)"
    ("htbm",
      "htmc",
      "htje",
      "qyr",
      "lxdh",
      "qyrq",
      "gys",
      "xmmc",
      "fzbm",
      "fzr") AS
  SELECT "contract". "Htbm",
         "contract". "htmc",
         "contract". "htje",
         "contract". "qyr",
         "contract". "lxdh",
         "contract". "qyrq",
         "contract". "gys",
         "project". "xmmc",
         "project". "fzbm",
         "project". "fzr"
    FROM "contract",
         "project"
   WHERE ("contract". "Gsxm" = "project". "Xmbm")

After building, open this view, no data is displayed. There are data in the contract and project tables. Thank you!

unkmass

Is there any result by directly executing the following statement?
SELECT "contract". "Htbm",
"contract". "htmc",
"contract". "htje",
"contract". "qyr",
"contract". "lxdh",
"contract". "qyrq",
"contract". "gys",
"project". "xmmc",
"project". "fzbm",
"project". "fzr"
FROM "contract",
"project"
WHERE ("contract". "Gsxm" = "project". "Xmbm")

cctvgun

Brother, where to execute this statement

unkmass

What database do you use, Oracle?

cctvgun

ODBC brought by PB

unkmass

ASA?

unkmass

Take a look at it in the DataBase Painter / ISQL Session.

cctvgun

Yes, Thanks

cctvgun

Where is ISQL Session? I have opened DataBase Painter

unkmass

You look in the interface, it's a window.
It can also be opened by view / interactive sql.