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 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? 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
Archived
This topic is now archived and is closed to further replies.