"SELECT U.USERID,U.NICK,A.USERNAME,U.MOBILE,U.EMAIL,U.ADDDATE,T.ORDER_TIME FROM USERINFO U TICKETORDER T LEFT JOIN ACCOUNT A ON U.USERID = A.USERID "
这个最后的那个LEFT 错了 能告诉我怎么写吗? 学生在此有礼了!
这个最后的那个LEFT 错了 能告诉我怎么写吗? 学生在此有礼了!
FROM USERINFO U
left join TICKETORDER T on ....
LEFT JOIN ACCOUNT A ON U.USERID = A.USERID
SELECT
U.USERID,U.NICK,A.USERNAME,U.MOBILE,U.EMAIL,U.ADDDATE,T.ORDER_TIME
FROM
USERINFO U,TICKETORDER T
LEFT JOIN
ACCOUNT A
ON
U.USERID = A.USERID
U.USERID,U.NICK,A.USERNAME,U.MOBILE,U.EMAIL,U.ADDDATE,T.ORDER_TIME
FROM
USERINFO U--,TICKETORDER T
LEFT JOIN
ACCOUNT A
ON
U.USERID = A.USERID
U.USERID,U.NICK,A.USERNAME,U.MOBILE,U.EMAIL,U.ADDDATE,T.ORDER_TIME
FROM USERINFO U ,
LEFT JOIN TICKETORDER T ON 关系
LEFT JOIN ACCOUNT A
ON U.USERID = A.USERID
FROM USERINFO U TICKETORDER T