that was me trying to alias the tables... perhaps I'm going wrong there... the result I'm getting at the mo is like a SELECT * I just get everything... as for the flavour... straight up MySQL 5.0database with a PHP twist maybe I should look at that FROM bit some more... cheers! PB