Reg : Counting Rows from Multiple tables ??[RESOLVED]

[kishore.kr]

hi guys,

i am creating a report for which i am not able to produce a query. 3 tables are involved in this qry and they are salesperson, first_contact and repeated_contact.

Relationship
=========
primary table --> secondary table
~~~~~~~~~~~~~~~~~~~~~~
1. salesperson -->first_contact
salesperson --> repeated_contact

2. first_contact --> repeated_contact

when a salesperson contacts a client(first time) the details will be added in the first_contact table along with his code(salesperson_code). if the same client is contacted again(may be by the same salesperson or by another which is not important at this point), the details of the contact will be added in the repeated_contact table along with his code(salesperson_code).

now i have to retrieve datewise reports of salesperson(date of contact is also added in both table). that is the number of clients a salesperson has contacted on a particular day. so the data should be retrieved from both the first_contact and repeated_contact tables. (i tried with group and joins, but i could not figure it out clearly). so guys please help me out.

actually i figured an alternative ie., retrieving data of both the table and putting in a temporary table and from there make the count. but if there is any other way(sql) then i would prefer that.

-- Kishore..