I have a PHP script that connects to our IBM DB2 Server (as400).
When I run
$query = "SELECT COUNT(row) FROM table";
$execute = odbc_exec($conn,$query);
$result = odbc_fetch_array($execute);
I get a response of 6611.
but when I run
$query = "SELECT row FROM table";
$execute =...
I don't have time to search anymore. I can not find the proper keyword.
I need help with a JOIN or a WHERE expression.
TABLE1 contains CASE_NUMBER
TABLE2 contains DEPT,YEAR,NUMBER
CASE_NUMBER is DEPTyearNUMBER
How do I format a JOIN or WHERE statement to use this info?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.