Re: Speaking of SQL.....

[x y <xy6581@xxxxxxxxx>]

UNION ALL.

On Fri, Mar 12, 2021 at 4:31 AM Richard Schoen <richard@xxxxxxxxxxxxxxxxx>
wrote:

> OK I have a new one. At least for me…..
>
> I have a need to query a single table with 2 different join criteria to
> pull out 2 distinct sets of records in a single query as one resultset.
>
> A two for one 😊
>
> Pseudo:
> Select * from table1 join table 2 on date and type=’FI’
> Select * from table1 join table 2 on type=’I’
>
> So the SQL isn’t real, but the concept question is.
>
> Can you execute 2 different queries together, sequentially, in tandem,
> whatever you want to call it… and return them together in a single
> resultset.
>
> I would rather not go the RPG or stored procedure route, but I will if
> needed. The results will be consumed by a PHP app.
>
> Thoughts appreciated.
>
> Regards,
> Richard Schoen
> Web: http://www.richardschoen.net<http://www.richardschoen.net/>
> Email: richard@xxxxxxxxxxxxxxxxx<mailto:richard@xxxxxxxxxxxxxxxxx>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com