I need help writing a query. There are three fields from three tables involved: File from the Files table, Path from the Paths table and Extension from the File Types table. The result of combining the three fields will look like the following:
The full path and file information “c:\images\image1.tif” has to appear in a single record. Any advice about how write the query will be greatly appreciated.