# Re: SQL又要如何下??

Posted by jutso on January 12, 1999 at 17:38:08:

In Reply to: SQL又要如何下?? posted by Someone on January 12, 1999 at 13:14:28:

: : 建议你用 sql 先建个表，再交给 crystal 印，不要用 crystal 的 formula ！
: RE:
: 我有试过但选不出我所要的，可能功力不够，那用SQL又要如何下才能选出我要的资料呢？范例或关键的SQL指令...期待!!!

SELECT invoice.*
FROM invoice
WHERE invoice.date in( SELECT Last(invoice.date)
FROM invoice
GROUP BY invoice.invoceno;
);

Follow Ups: