Re: Find rows in table A where table B = 'hello' AND table B = 'world'

David, How do I find all the tags that are tagged with the words "mysql" AND "databases" AND "tutorial"? If there are no url-keyword dupes in tbl_url_keyword ... SELECT u.urlid, u.url FROM tbl_url_keyword AS uk INNER JOIN tbl_url AS u USING (urlid) INNER JOIN tbl_keywords AS k USING (keywordi

Re: Find rows in table A where table B = 'hello' AND table B = 'world'

select a.urlid,a.keywordid,b.url,c.keyword from tbl_url_keyword a inner join tbl_url b on a.urlid=b.urlid inner join tbl_keyword c on a.keywordid=c.keywordid where c.keyword="mysql" or c.keyword="databases" or c.keyword="tutorial"; I think it´ll help you. "David Otton" <[EMAIL PROTECTED]> es

Find rows in table A where table B = 'hello' AND table B = 'world'

That's a lousy subject line, but I don't know how to describe this problem. I've been banging my head against this for a couple of days, and I'm certain there's a simple solution I'm missing. I've got a URL table, a keyword table, and a joining table, so each URL has a list of keywords applied