Join.

[Demonic]

Can someone tell me how I could order a table by another tables Id using Join mysql syntax.

Its confusing.

Select * FROM table1,table2 ORDER BY table2.id

Is that how I would do it?

[extrovertive]

A simple join

SELECT *
FROM table1 t1
JOIN table2 t2
ON t1.id = t2.id
ORDER BY t2.id

[Demonic]

can you explain that? the t1 and t2 threw me off bad.(same thing happened when looking at the manual ???)

[extrovertive]

t1 is just a short name label for table1.
You can still use the original table1 name.

SELECT *
FROM table1
JOIN table2
ON table1.id = table2.id
ORDER BY table2.id


same thing.

Another way to join is:
SELECT * FROM table1, table2
WHERE table1.id = table2.id
ORDER BY table2.id

However, the first method is better since there's more things with you can do using  a JOIN clause.

[Demonic]

K Thanks :) Ill try it now. (to see if it really works :O)