MySQL Forums
Forum List  »  Newbie

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


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

Written By
Why use JOINS when have FK
March 23, 2010 05:11AM

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.