Is there better control over the generated custom finder code in CMP?

[Alex Paransky]

By default you get: SELECT <column> FROM <table>, you can also add a WHERE
clause by playing with the <query></query>.  I need to get the following
format:

SELECT <column> FROM <table1>, <table2> WHERE <table1>.<column> =
<table2>.<column> and <table1>.<column> like $1

Is this possible?  In particular about the join from two tables?  Are there
any other tags I can add which will append something to the generated SQL
but before the WHERE clause?

Thanks.
-AP_