Re: Help to improve MySQL query
| From: | Micah Gersten | Date: | Mon, 11 Aug 2008 14:34:07 +0000 |
| Subject: | Re: Help to improve MySQL query | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45197@lists.php.net to get a copy of this message | ||
Use an appropriate status.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Dee Ayy wrote:
> On Fri, Aug 8, 2008 at 5:25 PM, Micah Gersten <micah@onshore.com> wrote:
>
>> How about "select Incidents.* from Incidents inner join Calls on
>> Incidents.id=Calls.incidentid where Calls.status='Open'"?
>>
> ...
>
>> Dee Ayy wrote:
>>
> ...
>
>>> The status column never has the text "Open".
>>>
> ...
>