> 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: > > 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 '%$query%' or title > LIKE '%$query%' or author LIKE '%$query%' > > for information id in bookcatalog and pricelist are same. > > thanks a lot > > Haidarpesebe
Hi, Can you be clearer please? _________________________________________________________________ Show them the way! Add maps and directions to your party invites. http://www.microsoft.com/windows/windowslive/products/events.aspx
