View Single Post
  #11 (permalink)  
Old 10-20-2007, 09:39 AM
kgun's Avatar
kgun kgun is offline
WebProWorld 1,000+ Club
WebProWorld MVP
 
Join Date: May 2005
Location: Norway
Posts: 6,117
kgun RepRank 10kgun RepRank 10kgun RepRank 10kgun RepRank 10kgun RepRank 10kgun RepRank 10kgun RepRank 10kgun RepRank 10kgun RepRank 10kgun RepRank 10kgun RepRank 10
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?
__________________
Mini Network:: Financial information at your fingertips
Learn object oriented programming where it started

I will use a search engine before I ask dumb questions.

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