MySQL Forums
Forum List  »  Newbie

Re: Why use JOINS when have FK
Posted by: Chad Bourque
Date: March 24, 2010 06:56PM

Andy,

Wow! You hacked that up pretty badly. ;)

The c, i1, i2, i3 are table aliases. When I put the table names in the from clause, I followed them with their alias. The alias is used to reference the table in the entire query.

from Clients c

I've given you a sample query. That's really all I can do without having your table structures. Perhaps, you should look back at it more closely. Everything you need is there. If you want to post your table structures (read the stickies for posting to see how to do that), I can probably give you the exact query. But, you really have not defined what you have or what you want, so it's kind of hard to just guess. :)

So, if you can't get what you need based on the example I provided, step back and then post a good request detailing what you have and what you want. I'll be happy to assist.

HTH,
Chad

Options: ReplyQuote


Subject
Written By
Posted
March 23, 2010 05:11AM
Re: Why use JOINS when have FK
March 24, 2010 06:56PM


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.