Re: bookmarks and keywords

Baron Schwartz schrieb:

> SELECT parent.bookmark_url as pbu, parent.bookmark_keyword as pbk
> FROM bookmarks AS child
> JOIN bookmarks AS parent
> ON parent.bookmark_keyword = child.bookmark_keyword
> WHERE child.bookmark_url='http://www.redhat.com';
>
> [..]

no, you didn't, you just switched the names ... :-/

but from his original point of view the row with the given URL was his parent and he wants to have all childs (identified by the same keywords) - now you have just switched the names - making the childs his parents and the parents his childs - this is confusing

just tell him: first the table which 'filters':

FROM parent WHERE ...

than the table he wants to select from:

SELECT ... FROM child

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

and now join them on the identifying field:

SELECT child....
FROM parent
JOIN child
USING (keyword)
WHERE parent...

-- 
Sebastian

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com