View Single Post
  #11 (permalink)  
Old 10-20-2007, 09:39 AM
kgun's Avatar
kgun kgun is offline
WebProWorld 1,000+ Club
 

Join Date: May 2005
Location: Norway
Posts: 4,948
kgun RepRank 3kgun RepRank 3
Default Re: How to Query 2 Tables (Not a join?)

Quote:
Originally Posted by jammybiskit View Post
You should consider amalgamating the tables into one with an extra column to distinguish between a,b,c and so on as rgcote suggested. You may need to do this if the performance is poor.
Yes that is a possible solution, like pulling fields / records from the table with PHP or another scripting language.
  1. What is the minimalistic solution that should be learned sooner or later?
  2. If (s)he can not use some type of joins, I question the structure of the database (collection of tables).
Why not ask on the MySQL forum?

Last edited by kgun : 10-20-2007 at 09:41 AM.
Reply With Quote