Re: joined query problem

[vishal barot]

hi there..

i think u can't do this in single query..

if u can it in single query its gr8....

in a single query i cant do that

if u r using php then first u can do this like :


$qry=mysql_query(" select price_cat_id from price_cat ");

while($result=mysql_fetch_assoc($qry)){

$pro_qry =mysql_query("select * from price where price_pricecat = ".$result["price_cat_id"]."")


}



like this......