[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 05:43:46
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.

Mark as Solved Mark as not solved

6 replies


	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.

6 replies

Mark as Solved Reply