[SOLVED] relational database question

[PHPro]

for example i have 2 different tables first one contains (id, username, posts) and the second one contains (id, age, whatever)... I want them to be related. like, i want an output in one table displaying every variables inside both of the table.

[kickstart]

Hi

 

You need a JOIN, to join the 2 sets together based on a common field.

 

Something like:-

 

SELECT a.id, username, posts, age, whatever

FROM table1 a

INNER JOIN table2 b

ON a.id = b.id

 

All the best

 

Keith

[PHPro]

Thank you so much. Very helpful