检索从不同的表在PHP Oracle数据库

SELECT RC.customer_id, RC.customer_number, RAA.address_id, RAA.customer_id FROM apps.RA_CUSTOMERS RC, apps.RA_ADDRESSES_ALL RAA WHERE RC.customer_number = 89

while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
$row['CUSTOMER_NUMBER']; //this works!
$row['RC.CUSTOMER_ID']; //this does not ...
$row['CUSTOMER_ID']; //this works, but how do I know which table is this from?
}

您可以使用RC.customer_id AS cid和RAA.customer_id AS raa_cid这样的ALIAS。

SELECT RC.customer_id AS cid, RC.customer_number, RAA.address_id, RAA.customer_id AS raa_cid FROM apps.RA_CUSTOMERS RC, apps.RA_ADDRESSES_ALL RAA WHERE RC.customer_number = 8

现在toy可以使用

调用它

$row['cid']; //the one from RA_CUSTOMERS
$row['raa_cid']; //the one from RA_ADDRESSES_ALL

如你所见，通过放置别名你可以调用它们并使用别名来打印

首先考虑使用JOIN语法。

其次，您总是可以显式地为列提供别名。

SELECT RC.customer_id rc_customer_id 
       ... 
       RAA.customer_id raa_customer_id
       ...

但是在这种特殊情况下，您可能既不需要第二列，也不需要别名。如果你想连接这两个表，它们将是相同的。

SELECT RC.customer_id, 
      ,RC.customer_number 
      ,RAA.address_id 
      -- you probably don't need this column ,RAA.customer_id 
  FROM apps.RA_CUSTOMERS RC JOIN apps.RA_ADDRESSES_ALL RAA 
    ON RC.customer_id = RAA.customer_id
 WHERE RC.customer_number = 89