Re: PL/SQL Calculated Fields - Simple I'm sure

stuart <stuart.lowes_at_ntlworld.com> schreef in berichtnieuws i6AM4.145$Ci6.3072_at_news6-win.server.ntlworld.com...
> I am very new to PL/SQL so if anyone can help I'll be grateful.
> What I need help with is writing some PL/SQL to count the number of lines
 an
> order has and display the number of lines an order has on a developer
 form.
> The order number is in one table and the order lines are in another. I'm
> sure its very simple to do but all the info I have is useless.
> Thanks in advance
> Stu
>
>

select count(*)
from orderlines
where ordernumber = <your order number in the order table>

Geezzz... Sigh

Sybrand Bakker, Oracle DBA Received on Sun Apr 23 2000 - 00:00:00 CDT