Re: SQL Select
| From: | Vojtech Dvorak | Date: | Thu, 20 Jul 2000 09:18:52 +0000 |
| Subject: | Re: SQL Select | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1319@lists.php.net to get a copy of this message | ||
Yes!
This solve my problem,
Thanks
Vojtech
----- Original Message -----
From: Carroll Barrett <cbarrett@inalt.com>
To: Vojtech Dvorak <vojtech_dvorak@servind.cz>; <php-db@lists.php.net>
Sent: Wednesday, July 19, 2000 6:50 PM
Subject: Re: [PHP-DB] SQL Select
> Try replacing this ...
>
> >SELECT TabFaultReport.SILTag, TabFaultReport.SerialNumber,
> >TabAccesories.Box, TabFaultReport.RANumber
> >FROM TabFaultReport INNER JOIN TabAccesories ON
> TabFaultReport.SILTag =
> >TabAccesories.SILTAG
> >WHERE (((TabFaultReport.RANumber)=6300));
> >
>
>
> with
>
> SELECT TabFaultReport.SILTag, TabFaultReport.SerialNumber,
> TabAccesories.Box, TabFaultReport.RANumber
> FROM TabFaultReport, TabAccesories
> WHERE TabFaultReport.SILTag =TabAccesories.SILTAG
> AND TabFaultReport.RANumber=6300;
>
> Regards,
> Carroll Barrett
>
>
>
>