Is the company field in the policy table? If so, this should give you what you want:
SELECT * ;
FROM client;
JOIN policy ON client.ssnumber = policy.ssnumber;
WHERE policy.companyname = "companya" OR policy.companyname = "companyb"
>Help,
>
>I have two tables, one client the other policy. What I'm trying to do is
>track the number clients that are covered by companya .and. compantb
>and charge .52 cents per client . The relationship between the two is
>SSNumber. I've seen so much code the last two days that I'm going nutty.
>Please send code sample
>
>Thanks