>Does foxpro 3.0b support relational algebra?
>
>For example, I have two tables, A and B. If I want the records which
>are in table A, but not in table B, shouldn't I be able to do the
>following (assuming the tables are union compatible):
>
>select * from A minus select * from B
>
>I say "shouldn't" because my database management textbook says that I should be able to do this. Looking through the on-line help as well as the mauals gave no answers, except by their absence, to suggest these commands are not supported.
>
>TIA
>
>marc mandel
Select * From A Where A.primarykey NOT IN (Select Primarykey From B)
Edward Pikman
Independent Consultant