I NEED A VB sql...

have two tables from one database: EMPLOYEE and DEPARTMENT

need from employee: employee name, id, and contact info
need from department: dept code, dept name, dept local num, and dept head...

what do i write in my adodc properties sql statement box and what do i write in the main code window when i call out the ado and its recordsource?