R&R SQL VERSION (JOINS)

[auspac]

[updated:LAST EDITED ON Jun-05-05 AT 11:15 PM (EST)]I am having trouble with the table JOINS Function__I have a master database eg FOCLT, with fields AREA & TYPE__I have a Table for Area and Type__I have created the joins foclt->area ----> area->farea, and on its own the join works, ok.____Sorry , have worked it out. ie Right click on the field name in the list and give an alias. !@!@ Should have looled a bit furthur before putting the question.!!!