Dan_Mason Posted May 31, 2011 Share Posted May 31, 2011 Hello! I am having an issue creating a view. To cut it short, I need to create a view from multiple tables in the same database. Some of these tables are formatted as dynamic tables i.e: Item_Name Item_Value Test1 1 Test2 2 Test3 3 And some are formatted as fixed tables i.e: Test1 Test2 Test3 1 2 3 Unfortunately I am not in control of how the database has been built and cannot (For the foreseeable future) change the construction of it. But in the mean time I am looking for a work around, that will allow me to create a fixed format view, that contains information from both types of table using multiple SELECT statements. I have read the documentation on the creation of a view and cannot seem to find any information specific to this topic! Any help on this would be greatly appreciated as I am currently stuck on this part of my project! Thanks very much for your time, Dan Quote Link to comment https://forums.phpfreaks.com/topic/237993-create-view-multiple-select-query/ Share on other sites More sharing options...
fenway Posted June 2, 2011 Share Posted June 2, 2011 I don't understand what you want -- to convert fixed to dynamic? Quote Link to comment https://forums.phpfreaks.com/topic/237993-create-view-multiple-select-query/#findComment-1224398 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.