[Vtigercrm-developers] OFFTOPIC mysql question

[David fire]

hi
this is an off topic sorry.

i have 3 tables

orders:
oid,cid,orderdate

customers:
cid,email,name

splits:
oid,quantity,ordprodisize

cid= uctomer id.
oid= order id.

i need to pick the last order of each customer before a date for example
2008-10-01
and the emal and the quantity,

please help.



if you help me i will be abel to finish to modules for vtiger.
a web soft phone.
and a module creator, yes a module to make new modules nice ;-)

David


-- 
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090214/6d97290d/attachment-0003.html