1b.) Example of Microsoft SQL Statement

SELECT DISTINCT [WellName]+"   #"+[WellNumber] AS Well, IIf([SurfaceLat]=",61.3493,[SurfaceLat]) AS Lat, IIf([SurfaceLong]=",-149.5377,[SurfaceLong]) AS [Long], [Wells - Public Header Data].[API_WellNo], [Wells - Public Header Data].[OperatorName], [Wells - Public Header Data].[PermitNumber], [Wells - Public Header Data].[TotalDepth], [Wells - Public Header Data].[AreaorBasin], ltbl_API_by_TABLE.API, [CompletionDate] FROM [Wells - Public Header Data] INNER JOIN ltbl_API_by_TABLE ON [Wells - Public Header Data].[API_WellNo] = ltbl_API_by_TABLE.API ORDER BY [WellName]+" #"+[WellNumber];

1b.) Example of Nested SQL Statement in visualbasic: (note the clause {WHERE (ltbl_API_by_Table.API) = """ & MyRS.Fields(8) & """} pulls the 9th field from the sql above; ie. {ltbl_API_by_TABLE.API} )

        strSQL = "SELECT ltbl_API_by_Table.Source_Table, ltbl_API_by_Table.IntervalTop, ltbl_API_by_Table.IntervalBottom, ltbl_API_by_Table.Records, ltbl_Table_HTML_Switch.Table_Label, ltbl_Table_HTML_Switch.Publish_Flag FROM ltbl_API_by_Table INNER JOIN ltbl_Table_HTML_Switch ON ltbl_API_by_Table.SOURCE_TABLE = ltbl_Table_HTML_Switch.Table_Name WHERE (ltbl_API_by_Table.API) = """ & MyRS.Fields(8) & """ ORDER BY ltbl_API_by_Table.Source_Table;"
'Print #2, strSQL