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...
