Is this correct? [message #147] |
Fri, 18 January 2002 13:35 |
Max Tay
Messages: 1 Registered: January 2002
|
Junior Member |
|
|
Set sqlStmt = "SELECT Lawyers.nric, Lawyers.first_name, Lawyers.last_name, " & _
"Lawyers.gender, Lawyers.firm, Firms.firm_code, " & _
"Firms.firm_code_1, Firms.firm_code_2, Lawyers.serial_no, " & _
"Firms.address, Firms.unit, Firms.postal_code, " & _
"Firms.building, Firms.tel_no, Lawyers.officer_code, " & _
"Officers.Name " & _
"FROM Lawyers, Firms, Officers " & _
"WHERE Lawyers.admission_no = '" & txtAdmissionNo & "' and " & _
"Lawyers.firm_name = Firms.name and " & _
"Lawyers.officer_code = Officers.code"
|
|
|
|