subquiries with MySQL 4.00???

[jordan880]

Hi, Please help. The following subquery works find in MySQL 5.022 but it does not work on MySQL 4.0 because I am Runing verson 5.0 local on my computer but my host company only running version 4.0.. so I am dying here. Thank you very much in advance for any information or help.

SELECT *
FROM tbl_product
WHERE tbl_product.subcategory_id = '10'
ORDER BY (:mad: 😕
SELECT company_name
FROM tbl_company
WHERE company_id = tbl_product.company_id
)

[Piranha]

Subqueries are not supported in MySQL 4.0, the first version where it worked was 4.1.

But why do you use a subquery? I think that a simple join would solve your problem:

SELECT *
FROM tbl_product
INNER JOIN tbl_company ON tbl_company.company_id = tbl_product.company_id
WHERE tbl_product.subcategory_id = '10'
ORDER BY tbl_company.company_name

By the way, only select the columns that you need.