Is It Possible to create a Join with Multiple Tables

2009-09-25 Thread c...@hosting4days.com
able2.id = table3.id WHERE table1.status = 'open'"; Q: Is something like this possible? Thanks, c...@hosting4days.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Basic SQL Query Help Needed

2009-08-25 Thread c...@hosting4days.com
ere status = 'open'" - -- then I'd like to get ALL the line items - in ALL these 'open' invoices - so how do I write the next SQL statement : $query_items = ??? "SELECT ID, NAME from lineitems where --xx??? xx--" ??? Thanks, c...@hosting4days.com