nested query help

[skdzines]

This may be a stupid question but I can't seem to figure it out. I'm receiving a syntax error when running the following query

Select h.domain_name, u.first_name, u.last_name, u.street_address_1, u.city, u.state, u.zip_code, u.country, u.phone, u.fax, u.email, h.payment_term, h.total_due_reoccur, (Select p.name
From payment_process p
Where p.pid = h.payment_method) as payment_method
From hosting_order h, user u
Where h.uid = u.uid
And h.status = 1

What I'm trying to do is get the value of the payment type (p.name) from the payment_process table where the p.pid is equal to the h.payment_method in the hosting_order table.

Can somebody please help?

Thanks

[Piranha]

A couple of questions:

1. What database do you run, and what version?
2. What error do you get, please copy-paste it.
3. why do you use a subquery instead of a (left) join?

[skdzines]

Actually, I think I've got it figured out using joins

Thanks