|
From: Gerd W. <ger...@t-...> - 2019-10-12 20:47:05
|
Please try to use UNION ALL instead of UNION. Gerd Am 10.10.19 um 20:19 schrieb Jack Brosch via Squirrel-sql-users: > SQL command is (ONLY difference is the % in front of RPT on 2^nd select : > > SELECT * FROM "VISION"."PUB"."PM_Program" > > WHERE "PM_Program"."ProgCode" like 'RPT%' and "PM_Program"."ProgCode" > like '%Label%' > > UNION > > SELECT * FROM "VISION"."PUB"."PM_Program" > > WHERE "PM_Program"."ProgCode" like '*/_%_/*RPT%' and > "PM_Program"."ProgCode" like '%Label%' > > Results are 1 record?? > > > > > > *Jack Brosch* > IT Report Developer > Jac...@es... > T: > M:704-622-6995 > > www.essentra.com > > > > > > *Essentra* > > , > United States of America > > This e-mail may contain proprietary information and/or copyright > material. This e-mail is intended for the use of the addressee only. Any > unauthorised use may be unlawful. > If you are not the intended recipient, you must not copy, distribute or > take any action in reliance on it. If you have received this email in > error, please delete it and notify us immediately by return email. > > Be aware that Essentra may monitor incoming and outgoing e-mails to > ensure compliance with the Essentra IT Usage policy. > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
