Forums
This topic is locked
Join Statement
Posted 25 Sep 2008 03:15:29
1
has voted
25 Sep 2008 03:15:29 Chris Trace posted:
Hey there,I need some help with a join statement. I need the lookup done on the second table using the field site ID
Table A --> Table B * Where id = Table A (id)
Any help
Thanks
Replies
Replied 25 Sep 2008 09:48:51
25 Sep 2008 09:48:51 Alan C replied:
try this link
www.wellho.net/mouth/158_MySQL-LEFT-JOIN-and-RIGHT-JOIN-INNER-JOIN-and-OUTER-JOIN.html
it shows the different types of join and how they are used
www.wellho.net/mouth/158_MySQL-LEFT-JOIN-and-RIGHT-JOIN-INNER-JOIN-and-OUTER-JOIN.html
it shows the different types of join and how they are used
Replied 29 Sep 2008 15:59:06
29 Sep 2008 15:59:06 Chris Trace replied:
nice thanks got something working well now