> Now, to complicate things further, suppose there is > yet another table (grandparent, let's say) and there is > a column in parent that is grandparent_id. I only want > results where parent.grandparent_id = 'Fred'. How do > I do that? Is it with a WHERE clause or some other > SQL magic? > > Dean > This is not meant as an "rtfm", but this helped me in the past.
http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins/ Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
