Trevor Rhodes wrote:
Hello All,
person_tb contains mem_id, lname and fname details_tb contains det_id and fin.
They both contain other fields, but I don't care about them at this time. I'm trying the following
select lname, fname from person_tb, details_tb where mem_id = det_id and fin = "y";
but it is giving me all 103 rows instead of just the ones I need.
How is it to know which ones you need? Add that logic to the where clause. An example would be much more useful than a vague description. Cut the data down to a smaller set and show us the problem.
Any help here would be most appreciated.
Regards
Trevor Rhodes
===========================================
Powered by Linux - Mandrake 9.1
Registered Linux user # 290542 at http://counter.li.org
Registered Machine #'s 186951
Mandrake Club Silver Member
Source : my 100 % Microsoft-free personal computer.
===========================================
19:37:04 up 2 days, 19:26, 1 user, load average: 0.95, 0.58, 0.69
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
