Re: Join Prblem
| From: | Todd Cary | Date: | Sun, 03 Dec 2000 21:30:09 +0000 |
| Subject: | Re: Join Prblem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-4989@lists.php.net to get a copy of this message | ||
I am not sure if this along the lines of what you want. Here I am
joining three tables. The DB is Interbase.
$inStmnt = "SELECT SC.SC_FRAME_ID, SC.SC_CODE, SC.SC_QUANTITY," .
"PR.PR_PRICE, R.PR_DESC,SC.SC_ID,PH.PH_SERIES_ID," .
"PH.PH_DATE,PH.PH_FRAME_LABEL " .
"FROM (SHOPCART SC JOIN PRODUCT PR ON " .
"SC.SC_CODE=PR.PR_CODE)" .
"JOIN PHOTOS PH ON PH.PH_ID=SC.SC_FRAME_ID " .
"WHERE SC.SC_SESSION_ID=" . $sid .
" ORDER BY SC_FRAME_ID";
Todd
--
Todd Cary
Ariste Software
todd@aristesoftware.com