SQL Select
| From: | Vojtech Dvorak | Date: | Wed, 19 Jul 2000 07:55:26 +0000 |
| Subject: | SQL Select | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1267@lists.php.net to get a copy of this message | ||
Hi,
I am trying to do this SELECT (it is taken from MS Access) with ODBC, PHP:
SELECT TabFaultReport.SILTag, TabFaultReport.SerialNumber,
TabAccesories.Box, TabFaultReport.RANumber
FROM TabFaultReport INNER JOIN TabAccesories ON TabFaultReport.SILTag =
TabAccesories.SILTAG
WHERE (((TabFaultReport.RANumber)=6300));
I can't do this with ODBC SELECT, so probably I can split it to two
different select commands. One for one table and another for second table...
Any other ideas?
Thanks
Vojtech