Anonymous
Anonymous asked in 電腦與網際網路軟體 · 2 decades ago

請說明下列SQL 指令中每一行的意義與作用

請說明下列SQL 指令中每一行的意義與作用。

SELECT x.company, y.order_date, y.shipped_on ;

FROM customer x, orders y ;

WHERE x.cust_id = y.cust_id ;

INTO TABLE custship.dbf

1 Answer

Rating
  • 2 decades ago
    Favorite Answer

    SELECT x.company, y.order_date, y.shipped_on

    FROM customer x, orders y

    WHERE x.cust_id = y.cust_id

    從 customer 和 orders 這兩個 table 中找出公司名、定貨日、及出貨日

    INTO TABLE custship.dbf

    將結果存入 custship.dbf 這個 table 中

Still have questions? Get your answers by asking now.