😡 I can't get Webyog to run a view, can someone write a correct view statement on here and so I can run it to see if something is wrong? Also does anyone know where I could get a list of codes for it? Thanks.
First of all you have to use MySql 5.0 to be able to create views. You should check out MySql manual's corresponding chapter on how to create and use views.