How to display two different database tables in php

Question

Navigation

#1 by (1 votes)
#2 by (0 votes)

0

>

php mysql

asked by anonymous 09.08.2014 / 16:52

2 answers

score 1 · Answer 1

1

You can use CROSS JOIN :

SELECT *
FROM tabela1
CROSS JOIN tabela2

09.08.2014 / 19:20

score 0 · Answer 2

Hello, another idea is to use UNION, but the tables must have the same structure and the same amount of columns, eg:

SELECT *
FROM   table1
UNION ALL
SELECT *
FROM   table2

or

SELECT t1.id, t1.nome
FROM   table1 t1
UNION ALL
SELECT t2.id, t2.nome
FROM   table2 t2