Recent content by mayyola
-
M
union subquery is not working in where condition
maybe i express not very well,i just want to know is there better codes to achieve the purpose. Thank you -
M
union subquery is not working in where condition
Hello,sonic8: Thank you for reply and it works.but if writing in the website code to query,i'm not sure it's suitable or not. because it's like a loop. @@ it seems not best way to describe.. Thank you -
M
union subquery is not working in where condition
error 3787 access two columns combine to one column Paperno | Expaperno ----------------------- a1 | a2 a3 | a4 become Paperno -------- a1 a2 a3 a4 SELECT * FROM jounals WHERE Paperno not in (select Paperno from payment where paid='1' and len(Paperno)>1 UNION ALL...