jemz — 2013-07-10T14:04:42-04:00 — #1
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.
compID empCompName companyimage
1 universalpicture image
7 Pixelite image
8 Vanchour image
r937 — 2013-07-10T20:14:41-04:00 — #2
use a LEFT OUTER JOIN with firsttble as the left table
jemz — 2013-07-10T21:17:11-04:00 — #3
Hi thank you for the reply...but it will only display one address if the second table match to the first table.
from firsttable frst right outer join
on frst.compid = scnd.compID
r937 — 2013-07-10T21:38:59-04:00 — #4
i suggested a left outer join
you wrote a right outer join
jemz — 2013-07-10T21:47:03-04:00 — #5
Hi sorry for that typo it must be left, yes i already tried the left outer join...it will only return one address.
r937 — 2013-07-10T22:04:15-04:00 — #6
please show your real query and your real tables, not the fake "firsttable" and "scnd"
jemz — 2013-07-12T14:22:26-04:00 — #7
Hi,Thank you...it's okay now