Home » SQL & PL/SQL » SQL & PL/SQL » Is this correct?
Is this correct? [message #147] Fri, 18 January 2002 13:35 Go to next message
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"
Re: Is this correct? [message #150 is a reply to message #147] Mon, 21 January 2002 01:02 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

could u explain little bit more?

cheers
pratap
Previous Topic: SCRIPT TO CREATE HOST STRING
Next Topic: URGENT: To select newly entered values in Trigger
Goto Forum:
  


Current Time: Thu Mar 28 16:27:13 CDT 2024