hi,

case is quite simple
i have 2 tables that have different number of rows and i want to join them.
unfortunately they have tha same column names

i use full outer join to show all records from the first table even if there is no connection between those two table and the same with the second table

then i want to insert records when employeeid from the first table is null
and update...