Cancel this,.. after loading some test data into the tables, both queries worked
perfectly and are using the indices as expected! :)
Thanks again for all the help gang! ;)
>>Tried a couple of variation querys, but I keep getting the results when I do
>"explain"
>>
>>QUERY #1
>>explain select t.tagnumber,m.days,m.expdate from tags t
>>left join membership m on m.tagid = t.tagid
>>where t.orderid = '2';
>>
>>QUERY #2
>>explain select t.tagnumber,m.days,m.expdate from tags t,membership m
>>where t.orderid = '2' and t.tagid = m.tagid
>>
>>I get the results:
>>Impossible WHERE noticed after reading const tables
>>
>>Not sure this has anything to do with it, but there is no data in either table yet,
>we just set it up and are in the process of putting into production and the end of
>the week. I just wanted to get the queries setup, make sure they're using the correct
>index and such, so we can extract the required data when needed.
>>
>>The orderid is what determines which what all should be extracted, from another
>table, "customers" each account is created in a "customer" table, the orderid is an
>auto increment type and this is what ties the "tags" and "membership" table to the
>"customer"
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
