mysql4 lack of functionality workaround?

So it seems mysql 4 doesn't support views, something even foxpro for DOS did.

Any suggested hacks/ways to fake it?

I want functionality of something really simple like:

create view temp as select x,y from table1, table2 where table1.z=table2.z

very, very basic stuff.

 

 

 

 

Top