Posted on 2005-05-12
I have two tables which are joined by a field called "File_Num":
These 2 tables are linked by the string field "Fine_Num". This field is unique in Table1, but can repeat in Table2. If I want a query that will return all File_Num's in Table1, together with the first (or otherwise any) occurance of Name in Table2, is this possible?
So if in Table1, File_Num = 'R00001', and in Table2 there are two matching records for this File_Num, say 'John Doe' and 'Justin Smith', it should return only the first one (or if not possible any one):
R00001 John Doe