General information
Category:
Coding, syntax & commands
>>I what to find all duplicates of lastname+firstname and then if any of these name don't have any data in the child table arcpinfo,
>
>In VFP 9, you can find these records with a query like:
>
>
>SELECT lastname, firstName, CNT(*) ;
> FROM ( ;
> SELECT * FROM ARCPerson ;
> WHERE ID NOT IN (SELECT ID FROM ARCPInfo)) NoInfo ;
> GROUP BY 1,2
>
>This assumes that you have a primary key field in ARCPerson called ID and that ARCPInfo has the same ID field to link the two tables.
>
>Tamar
thanks
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only