My group 2 table data, extracting data window
The SELECT agentmsc_base tdhao,
Agentmsc_base chming,
Agentmsc_base hci,
Agentmsc_base d_port,
Agentmsc_base c20,
Agentmsc_base c40,
Agentmsc_base c40h,
Agentmsc_fyong fymcheng,
Agentmsc_fyong f_shorf,
Agentmsc_fyong fyjer,
Agentmsc_fyong. Fyjer_u
The FROM agentmsc_base,
Agentmsc_fyong
The WHERE (agentmsc_base. Tdhao=agentmsc_fyong. Tdhao)
And ((agentmsc_fyong dwmcheng like: s_dwmcheng) and
(agentmsc_fyong fymcheng like: s_fymcheng) AND
(agentmsc_fyong f_ok like: s_f_ok) AND

(agentmsc_base wdate & gt;=: dt_date1) AND
(agentmsc_base wdate & lt;=: dt_date2) AND
(agentmsc_base line_opter like: s_line_opter) AND
(agentmsc_base line_owner like: s_line_owner) AND
(agentmsc_base wtdwei like: s_wtdwei) AND
(agentmsc_base wtdwei_owner like: s_wtdwei_owner) AND
(agentmsc_base line_name like: s_line_name) AND


Agentmsc_base. F_stage & lt;> '0' AND
Agentmsc_base. F_stage & lt;> '1' and
Agentmsc_fyong. F_shorf='S' AND
AGENTMSC_BASE. ROLL_OVER & lt;> '1' AND
AGENTMSC_BASE. ROLL_OVER & lt;> '3')
The ORDER BY agentmsc_base chming ASC,
Agentmsc_base. Hci ASC,
Agentmsc_base. Tdhao ASC

Agentmsc_base table primary key is TDHAO and agent_fyong foreign key, is the primary key in the agentmsc_fyong

Tdhao + fymcheng + f_shorf

I want to use the packet data window implementation according to certain conditions (these conditions both in agentmsc_base columns, also involved
Agentmsc_fyong column) in the eligible fyjer agentmsc_fyong, fyjer_u put forward in the group, a group of
,
Start the SQL is my handwriting, but always can't realize if the conditions in the
(agentmsc_base wdate & gt;=: dt_date1) AND
(agentmsc_base wdate & lt;=: dt_date2) AND
(agentmsc_base line_opter like: s_line_opter) AND
(agentmsc_base line_owner like: s_line_owner) AND
(agentmsc_base wtdwei like: s_wtdwei) AND
(agentmsc_base wtdwei_owner like: s_wtdwei_owner) AND
(agentmsc_base line_name like: s_line_name) AND
Remove retaining other conditions can achieve surplus condition query, but with these conditions is wrong!!!!!!!!!!

CodePudding user response:

You can directly use the SQL statement in the SQL query analyzer detected data correctly?

CodePudding user response:

reference 1st floor smilysoft response:

you use SQL statements directly in the SQL query analyzer can correctly detect the data?

I can retrieve the content, I have to like '%' and then delete the date condition, in the analyzer can retrieve the data DE!

CodePudding user response:

refer to the second floor XXJCHQ response:

reference 1st floor smilysoft response:
You can directly use the SQL statement in the SQL query analyzer detected data correctly?
I can retrieve the content, I have to like '%' and then delete the date condition, in the analyzer can retrieve the data DE!

Don't do this check, you can through the getselectsql () function to check the production after the input parameters of SQL statements, use SQL to perform