This is not a sales post. I have been struggling with JOINed SELECT statements for a while now. The syntax just seems to elude me. However, I just found a Win Dreamweaver extension that rocks. The Advanced Query Wizard allows me to very quickly and easily write sophisticated, joined queries with conditionals and sorting from many tables at once. It has made my life considerably easier so I wanted to pass on the information.
https://www.advancedextensions.com/products.htm Thanx -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams ---------------------------------------------------- http://www.digitaliguana.com http://www.cancerreallysucks.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]