Need help with a script/procedure

From: Yikes <Yikes_at_yahoo.com>
Date: Fri, 08 Dec 2000 11:57:42 -0800
Message-ID: <3A313D36.54F3369E@yahoo.com>

I've been asked to write a script and I must admit that my sql/plsql skills
are a little on the light side being a pure operations type DBA :-)

Basically the gist of it is the following:

Need to pull data from two tables: customers, profile

The customer table has a customer_id and a parent_id The profile has a customer_id

I don't want data pulled if the customer.parent_id is null for that particular customer.customer_id

If the customer_id is NULL in the profile table, I need to return a message indicating
that there is No Profile for that Customer.

Sorry if this is unclear, but help would be appreciated.

TIA Received on Fri Dec 08 2000 - 13:57:42 CST