WHERE TRANSPORT_DATE=DATE_ADD (CURDATE (), INTERVAL - 2 DAY) TTT TTT represent

CodePudding user response:

Is there a big solve!

CodePudding user response:

The subquery rowset alias

CodePudding user response:

This should be the second half of the subquery is similar to the following SQL

Select * from (select a from the database. Table1 where a> 1) as TTT

Had better send a complete SQL can more accurate explanation, TTT is what

CodePudding user response:

You this is not all
Braces are in
TTT representative/(SELECT... FROM... WHERE TRANSPORT_DATE=DATE_ADD (CURDATE (), INTERVAL - 2 DAY) the results

The content of [] is you don't have the copy

CodePudding user response:

The SELECT a.f a_num - NET_WEIGHT FROM bw_db. Bs_LOGISTICS_DETAIL_PRICE a JOIN cp_db. BS_DECREASE_FACTORY b ON a.f a_num=b. a_code
WHERE TRANSPORT_DATE=DATE_ADD (CURDATE (), INTERVAL - 2 DAY AND a.f a_name LIKE '% % electricity) TTT

Bosses, this is a full, and then explain to me

CodePudding user response:

You complete the executing an error?