RE: select data from two table and will sort by price in second table

> From: haidarpes...@gmail.com > To: mysql@lists.mysql.com > Subject: select data from two table and will sort by price in second table > Date: Wed, 29 Apr 2009 10:46:48 +0700 > > dear all, > please help us mien for select data from two table with details as follows

select data from two table and will sort by price in second table

dear all, please help us mien for select data from two table with details as follows: primery tabel : bookcatalog second table : pricelist for seaching we will try to sort by price (in second table). our databese details like this: SELECT id, title, author from bookcatalog where isbn LIKE '%$q