I want to join 2 tables . The first one has 30 elements and the second one has max (30) elements but in most cases they are less. I want to join the tables and the result to be 30 rows again and there MUST exists one condition that puts the elements form the second table in the specified row depending on the values of the first table and the remaining cells that has no coresponding elemnt can contain everything...even NULL... PLEASE HELP!!!!