Jump to content

Create View Multiple Select Query


Dan_Mason

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.