Help with ordering

[UnknownPlayer]

Here is question:

i have db articles and categories.

Now at categories i have:

- id

- name

- info

and at articles there are:

- id

- cat_id

- name

- description

- date

 

Now i wonna get all articles like "SELECT * FROM articles", but i wonna order it by categories name, how can i do that?

[BlueSkyIS]

SELECT A.* FROM articles A, categories B WHERE A.cat_id = B.id ORDER BY B. name

[UnknownPlayer]

What is A and B ? :S

[BlueSkyIS]

http://www.brainbell.com/tutorials/MySQL/Using_Table_Aliases.htm

[BlueSkyIS]

I had a bad space before .name. should be

 

SELECT A.* FROM articles A, categories B WHERE A.cat_id = B.id ORDER BY B.name

[UnknownPlayer]

Hmm do i need to put "AS" somewhere?

[PFMaBiSmAd]

'AS' is optional. Did you even try the query that was posted?

[UnknownPlayer]

No i didn't but i will now..