2. PHPRunner General questions
  3. [SOLVED]  How do I combine more than one table?
This topic is locked
[SOLVED]

 How do I combine more than one table?

 		1/6/2011 5:43:46 AM
PHPRunner General questions
D
 danaci author

hi,

PHPRunner union is not supported in this case is the solution?

How do I combine/merge more than one table?
regards.
Sergey Kornilov admin 1/6/2011

Are you sure you talking about UNION and not about JOIN?
In case of UNION you need to create a view right in your database.
D
 		danaci author 1/6/2011

dear admin,

yes with union.
table1

name v(30),

tel v(30)
table2

name2 v(35),

tel v(20),
table3

sname v(40),

tlf v(10)
how to merge three tables without UNION?
regards.
Sergey Kornilov admin 1/6/2011

Depends on what 'merge' means. How do you want to merge those tables?
D
 		danaci author 1/6/2011

dear admin,
I want to all column listing.

ex. of listing

name of personal name of personal tel

name tel

... ...

... ...

name2 tel2

... ...

... ...

... ...

sname tlf

... ....

... ....
thnx for reply.

regards.
Sergey Kornilov admin 1/6/2011

You need to create a View in your database for this purpose using UNION.
D
 		danaci author 1/7/2011

thnx dear admin.

perfect.

this issue resolved

regards.