Recent content by Ben_P

Thats great thanks a lot for your help! I'll check out the query designer didn't know it even existed in mysql yog. :D

Thanks for explaining much appreciated, its my first time using SQL and I am just trying to get the ball roling ;) If I wanted to list the daily rate hire for example for three differant movies how well do you think the following statement would do? select DailyHireRate as Remuneration...

Thats awesome guys thanks a lot!! Would that statement list the names in alphabetical order aswell?

Hi all, I am creating a MySQL database and creating the database based around a DVD Company and just wondering if anyone could help me out with a little SQL statement problem I have (First time using MySQL) I want to List the first and last name of all the staff (for example) working at the...