I am setting up a recordset using the following code and SQL statement:<BR><BR>Dim rsCurrentLadders As New ADODB.Recordset<BR>Dim strCLad As String<BR> <BR>strCLad = "SELECT Ladders.LadderName " & ...
Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...