From: esquel@sommarskog.se   
      
   Tony Johansson (johansson.andersson@telia.com) writes:   
   > How can I do this in MySQL or using a view. I want a more standard   
   > solution that works in more db then just SQL Server.   
      
   Well, this is a forum for SQL Server, so here you will get answers for   
   SQL Server. If you want answers for MySQL, you need to try a MySQL forum.   
      
   However, I believe that the query I posted is compliant with the SQL   
   standard, and does not include any proprietary constructs. On the other   
   hand, just because a query is standards-compliant is no guarantee that   
   it will run on all engines.   
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)