Could you tell me the multi-table connection statement from ACCESS to SQL SERER when how should change, the statement is as follows: thank you,

 
SHAPE 
{
SELECT c. user number, c. username, c. table number, c. phenotypic name, c. billing type, c. billing category, c. monovalent, c. the number of purchase, and c. purchases, 
C. purchase amount, c. operators, c. operation type, c. paper number, c. effectiveness, d. last time balance, d. cash balances, paid-in amount FROM 
(
(
SELECT b. user number, user name, b. b. table number, name of phenotype, b. b. billing type, b. billing category, 
B. The unit price, purchase frequency, b. b. purchases, purchase amount, b. b. operator, operation type, b. b. paper number, 
B. b. effectiveness, fixed number of times the FROM 
(SELECT * FROM yhxx WHERE user id=16) AS a 
LEFT the JOIN 
(SELECT * FROM SDJL WHERE paper number=20 AND effectiveness=type='buy' AND 'effective') AS b ON a. user id=b. user id 
) AS c 
LEFT the JOIN 
(SELECT * FROM yueb WHERE paper number=20) AS d ON c. user id=d. user number AND c. notes number=d. note number 
) 
The order by c. user number, c. table number 
} 

AS Command1 
As COMPUTE Command1 Command2 
BY [user id], [username], [bill number], [the last balance], [cash balances], [paid-in amount], [operator], [type] operation 

CodePudding user response:

Don't understand, help the top...

CodePudding user response:

If available, in the access and essentially a table structure and access, directly take the past try. Reading the wrong information for debugging

Personal advice: don't directly naming the names of the tables and fields in Chinese. If need to load the form controls show. You can put that in the table fields that

CodePudding user response:

A similar problem