<?php$name = 'IBM';$q = new ezcQuerySelect( ezcDbInstance::get() );// Creating subselect object$q2 = $q->subSelect();// $q2 will build the subquery "SELECT company FROM query_test WHERE// company = :ezcValue1 AND id > 2". This query will be used inside the SQL for// $q.$q2->select( 'company' ) ->from( 'query_test' ) ->where( $q2->expr->eq( 'company', $q2->bindParam( $name ) ), 'id > 2' );// $q the resulting query. It produces the following SQL: // SELECT * FROM query_test// WHERE id >= 1 AND // company IN ( (// SELECT company FROM query_test// WHERE company = :ezcValue1 AND id > 2// ) ) $q->select('*') ->from( 'query_test' ) ->where( ' id >= 1 ', $q->expr->in( 'company', $q2 ) ) ); $stmt = $q->prepare();$stmt->execute();?>