I need distinct on Dodah.A, Dodah.B The other joins are simply ties to additional tables that I need to know records exists in - I need the data from them for display or counting purposes on reports.
I Have one table (Dodah) that is always unique on Dodah.A, Dodah.B - I wonder if I could somehow join this back to itself to get a unique recordset?
inner join dodah DDD ON DDD.A = Dodah.A ???
hmm - might work!
The frustrating thisg is this is so easy in Fox!!
>Because you have the 5 fields listed, there IS not distinct do to the "Blah" table columns that have different city/zip fields... (or at least thats what they appear to be).
>
>In the sample data you showed, it appears to be a 1 to 1 ratio for Dodah and Big for each key "A" column.
>
>However in table "Blah", you have 2 entries for each "A" key... one for Jackson and one for Vicksburg.
>
>What Distinct records to you want... the Dodah/Big with the last entry in the "Blah" table for associate key or what...