[Resolved] Join tables and order by problem..

[The_Chancer]

I have a little problem with regards to ordering on a table.

I have one table layout like so

tablename = enquiry
ref (int)
agentname (int)
details (text)

tablename = agents
ref (int) - same as in enquiry.agentname
name (varchar)
details (text)

What I ideally want to do is list all the rows in enquiry ordered by the agentname alphabetically as in the agents table

I have a feeling it will be done by some form of JOIN and ordered by agents.name but I am unsure of how or which..

Using MSSQL2000..

Any ideas ?

Cheers,

[The_Chancer]

Ah ha....

I was right <eventually>

"SELECT * FROM enquiry AS E INNER JOIN agents AS A on E.agtco_name=A.ref WHERE orighotelid='".$_COOKIE['ccslocation']."' AND func_date!='' AND enquiry_type in ('Enquiry','Provisional') ORDER BY A.company $type";