if i understand your issues, then i think you need to use <b>left outer join</b> in your query.
for example,
<pre lang="SQL">Select employee.name,isnull(salary.salary,0),employee.id from employee left outer join salary on
employee.id = salary.employeeid</pre>
for your second issues, if you insert a value to your first table without inserting value to second table,above sql (left outer join) will return salary as 0.
i think it will solve your issues. let me know, if it not.