Hi i need some help on this, how can i join this two tables to display all the records even the first table has no match in second table and only to display one company image..is this possible? I tried to use the inner join but the image is displaying 3 times because i have match in second table with 3 7's,but i cannot display the image even it is not match in second table.

can you help me on this please

Thank you in advance.


firsttble

Code:
compID      empCompName                      companyimage
  1             universalpicture                       image

  7              Pixelite                                 image

   8             Vanchour                              image
secondtable
Code:
  compID                  Address                  
    7                          Texas

    7                          Sweeden

    7                          Mexico