Try: select t1.*, t2* from table1 as t1, table2 as t2 where
t2.date>='2001-02-04' and t2.date<='2001-02-06' and t1.id=t2.id and
t2.no_of_items>=1
>>Here is where I'm at:
>>mysql> SELECT t1.*, t2.*
>> -> FROM Table1 t1, Table2 t2
>> -> WHERE t2.date BETWEEN "2001-02-04" AND
>>"2001-02-06"
>> -> AND t1.id=t2.table1_id
>> -> AND t2.no_of_Items >=1;
Jeff
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
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
