Identify differing records in two tables by query.

[jlockley]

Is there a way to compare two databases of same or different structure to see which members differ on one field.

The format Name (key) Last name (keyed)...<same or differing fields>..<expiration date>

I would like to extract the records with differing expirations dates.

 

[TonyMcGuire]

qbe=query

tblA.db | name | last name | expire |
| _a | _b | _c |

tblB.db | name | last name | expire |
checkplus | _a | _b | not _c |

endquery


Is this what you mean? OR do the name fields not even need to be in there?



Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities

 

[jlockley]

AHA!!! (sound of quarter dropping in the slot and machinery slowly turning). I think it is exactly what I need. I will try it at once. Thank you! I didn't know/think you could use NOT thusly.