Hi How can i re-write this so i

[Forri]

Hi

How can i re-write this so it can suit my mySQL version:

select

pl_stockid,
(select stock_name from tblstocks where stock_id = pl_stockid) as stock_name,
(select stock_thumbnail from tblstocks where stock_id = pl_stockid) as stock_thumbnail

from tblpricelist
where pl_price2 <= 50
group by pl_stockid

Thanks

 

[sleipnir214]

Using joins. Something like:

select
p.pl_stockid, s.stock_name, s.stock_thumbnail
from
tblpricelist p
join
tblstocks s
on p.pl_stockid = s.stockid
where
p.pl_price2 <= 50
group by
p.pl_stockid


See also the MySQL online manual entry for rewriting queries to remove subqueries:

http://www.mysql.com/doc/en/Rewriting_subqueries.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Forri]

It still doesn't work! it states:

[Administrator] ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on p.pl_stockid = s.stockid

where
p.pl_price2 <= 50
group b

 

[sleipnir214]

The query does not generate any syntax errors for me.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Forri]

Found it!! Thanks