Creating Where condition

[devanshusharma19]

Hi,
can you help me for creating sql query in where condition

SELECT
*
FROM
classicmodels.offices t1
INNER JOIN classicmodels.employees t0 ON (t1.officeCode = t0.officeCode)
INNER JOIN classicmodels.customers t2 ON (
(t0.employeeNumber = t2.salesRepEmployeeNumber)
OR (t0.firstName = t2.contactFirstName)
)
WHERE
(t2.creditLimit > 70000)
AND (t2.creditLimit < 100000)
OR (t0.officeCode = 6)

ORDER BY
t0.firstName ASC

I am not able to create please tell me how to create AND or OR both condition in single query

WHERE
(t2.creditLimit > 70000)
AND (t2.creditLimit < 100000)
OR (t0.officeCode = 6)

[jkrasnay]

Hi,

I'd just put that whole expression in a single where call. Make sure you put parens around the whole thing in case you add other where clauses later. Also, I'd put parens around the and subexpression.

selectCreator
.where("(((t2.creditLimit > :p1) and (t2.creditLimit < :p2)) or (t0.officeCode = :p3))")
.setParameter("p1", 70000)
.setParameter("p2", 100000)
.setParameter("p3", 6);

[devanshusharma19]

Hi,
How can create dynamic query may more then one time AND condition or may be more then one time OR condition. it's condition comes random. then i want to create query. can you help me....