V
ValD
Hello: I need to run a query that displays information regarding
clients from three different tables each joined by a client id field.
The first table contains general info regarding the customer (address,
phone, etc.), the second lists workshops enrolled and completed, the
third displays referral details (date of referral, name of referring
organization). The query should display all clients whether they
enrolled in a workshop or not and whether they were referred to
another organization or not. The problem is when I run the query it
excludes any record that contains a null value for workshops and
referrals (thereby reducing the number of record from over 200 to 4).
Please help!
clients from three different tables each joined by a client id field.
The first table contains general info regarding the customer (address,
phone, etc.), the second lists workshops enrolled and completed, the
third displays referral details (date of referral, name of referring
organization). The query should display all clients whether they
enrolled in a workshop or not and whether they were referred to
another organization or not. The problem is when I run the query it
excludes any record that contains a null value for workshops and
referrals (thereby reducing the number of record from over 200 to 4).
Please help!