MySQL Forums :: Newbie :: Why use JOINS when have FK


Advanced Search

Why use JOINS when have FK
Posted by: Andy Deans ()
Date: March 23, 2010 05:11AM

Hi,

This is probably a really simple answer so hopefully someone can help, i setup my db with FK's using InnoDB storage engine.

What i end up having to do, and what advice i normally get is to do a query use :

INNER JOIN or JOIN to get the tables together. I though if i had a FK that created the relationship or am i missing the point?

Thanks for anyone who can answer this for me.

Options: ReplyQuote


Subject Written By Posted
Why use JOINS when have FK Andy Deans 03/23/2010 05:11AM
Re: Why use JOINS when have FK Chad Bourque 03/23/2010 07:57AM
Re: Why use JOINS when have FK Andy Deans 03/24/2010 05:12AM
Re: Why use JOINS when have FK Chad Bourque 03/24/2010 08:54AM
Re: Why use JOINS when have FK Andy Deans 03/24/2010 03:09PM
Re: Why use JOINS when have FK Chad Bourque 03/24/2010 03:46PM
Re: Why use JOINS when have FK Andy Deans 03/24/2010 04:35PM
Re: Why use JOINS when have FK Andy Deans 03/24/2010 04:38PM
Re: Why use JOINS when have FK Chad Bourque 03/24/2010 06:47PM
Re: Why use JOINS when have FK Chad Bourque 03/24/2010 06:56PM
Re: Why use JOINS when have FK Andy Deans 03/25/2010 05:16AM
Re: Why use JOINS when have FK Chad Bourque 03/25/2010 08:51AM
Re: Why use JOINS when have FK Andy Deans 03/25/2010 09:20AM
Re: Why use JOINS when have FK Chad Bourque 03/25/2010 11:38AM
Re: Why use JOINS when have FK Andy Deans 03/25/2010 12:28PM
Re: Why use JOINS when have FK Chad Bourque 03/25/2010 12:47PM
Re: Why use JOINS when have FK Andy Deans 03/25/2010 12:52PM
Re: Why use JOINS when have FK Chad Bourque 03/25/2010 01:54PM
Re: Why use JOINS when have FK Andy Deans 03/25/2010 02:16PM
Re: Why use JOINS when have FK Andy Deans 03/25/2010 09:24AM
Re: Why use JOINS when have FK Chad Bourque 03/25/2010 11:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.