hi<br>this is an off topic sorry.<br><br>i have 3 tables <br><br>orders:<br>oid,cid,orderdate<br><br>customers:<br>cid,email,name<br><br>splits:<br>oid,quantity,ordprodisize<br clear="all"><br>cid= uctomer id.<br>oid= order id.<br>
<br>i need to pick the last order of each customer before a date for example 2008-10-01 <br>and the emal and the quantity,<br><br>please help.<br><br><br> <br>if you help me i will be abel to finish to modules for vtiger.<br>
a web soft phone.<br>and a module creator, yes a module to make new modules nice ;-)<br><br>David<br><br><br>-- <br> (\__/) <br>(='.'=)This is Bunny. Copy and paste bunny into your <br>(")_(")signature to help him gain world domination. <br>
<br>