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.
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
--
Never mud wrestle with a pig.. you get dirty and the pig enjoys it!
Never try to teach a pig to dance. You waste your time and annoy the pig.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
