> I would like to select all the records in the tasks table, the result > however should contain the values from the Categories and Status table. I > hope this makes sense. That sounds like a table join to me. Here's an article that should help you figure them out: http://www.devshed.com/Server_Side/MySQL/Join/page1.html Cheers, Beau