Dear Sir:

Suppose that I have a table called Employee which has the folloing fields:

name,
date-of-birth,
title,
phone_number

I want to write a SQL query using ibatis SQLMAP which will return a list of names which have the matching titles

The matching titles are containend in an array or list. The number of the element in the array or list may vary.
How can I write a SQL to do the job ?

SELECT name
FROM Employee
WHER title = ????


Thanks,

John Chien

begin:vcard
fn:John Chien
n:Chien;John
email;internet:[EMAIL PROTECTED]
tel;work:919-715-2510
version:2.1
end:vcard

Reply via email to