Joe,
I wouldn't leave fields ddate and cCategory without 'Cat.' and if you are under
VFP9, I'll write
SELECT led.iCat_Id, cat.ddate, Led.iCat_Id, cat.cCategory ;
FROM cat INNER JOIN led ON cat.icat_id = led.icat_id ;
INTO CURSOR myresult
You can detect if the same icat_id belongs to more than one line in cat with
SELECT icat_id, COUNT(*) AS nb FROM cat ;
GROUP BY icat_id HAVING COUNT(*) > 1 ;
INTO CURSOR plus1
HTH
The Foxil
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
