Home > database >  Which friend to help me have a look at what's the problem with this according to SQL statements
Which friend to help me have a look at what's the problem with this according to SQL statements

Time:10-06

The select dfyyz dfadd, DFHH DFBH, dftype, DFZS, DFBS, DFDL, dfje, dftime, DFBZ
Into: ddlb_dfyyz. Text, : sle_dfadd. Text, : sle_dfhh. Text, : sle_dfbh. Text, : ddlb_dftype. Text, : sle_dfzs. Text, : sle_dfbs. Text, : sle_dfdl. Text, : sle_dfje. Text, : sle_dftime. Text
The from dianfei
Where id=3;

CodePudding user response:

Dfyyz dfadd, DFHH DFBH, dftype, DFZS, DFBS, DFDL, dfje, dftime, DFBZ
These have a date?

The field type is in?

CodePudding user response:

I think there is also a type matching problem, can't see from this, because the information you give is too little.

CodePudding user response:

See if fields and variables match?

CodePudding user response:

There are two table table a and table b now I want to get rid of some data table a table b line (meaning table a and table b which data exactly put it removed `) ` ` to select out a new table a
MINUS collection of Oracle can do ` ` ` but I was using a t-sql
Known two same table structure
Six field
please use abcdef generationCan use an SQL statement to achieve best ` ` because want to fill in the winForm to list
Available storage process ` ` `
Master 99999

CodePudding user response:

If not directly in the SQL statement, : sle_dfdl. Text, : sle_dfje. Text, : said in pb, followed by is variable, you use variable test
  • Related