►
From YouTube: TTEOT Training Video - S1E10 - SQL: Unions
Description
In order to form a more perfect union... you need to watch this video! We'll go over how to show the results of multiple queries in a single report.
Music: https://www.bensound.com
B
A
And
today
this
is
another
thrilling
episode
of
every
other
thursday
coho
videos
and
we're
going
to
be
talking
about
some
more
sql
stuff
and
right
now,
I'm
at
the
coho
us
site,
which
is
at
coho
dash
us.org,
and
you
can
find
what
we've
done
already.
If
you
go
to
the
link
that
says,
learn
from
quahog
us
and
then
there's
the
link
here
that
says
you
kaha
us
videos,
there's
a
whole
list
of
these
videos.
A
A
A
A
A
A
So
in
this
first
one
we've
got
fourteen
thousand
three
hundred
and
thirty
results
and
then
the
second
one
we've
got
two
hundred
and
twenty
two
thousand
sixty
five
results,
and
in
this
one
we've
got
all
of
those
results
together
in
one
big
in
one
place
now
in
and
of
itself,
let
me
show
you
how
we
do
this
in
and
of
itself.
That's
not
helpful,
but
if
we
were
doing
like
a
sub
query,
if
we
we
could
use
this
data
as
a
sub
query
and
another
query
to
to
get
things
out
of
this
table.
B
B
A
A
A
Sql
doesn't
know
how
to
output
that
kind
of
data,
but
so
now
I've
got
a
report
that
essentially,
what
I've
got
is
a
gigantic
list
of
every
reserve,
every
request,
that
is
in
the
system,
whether
it's
just
been
placed
or
whether
it's
already
been
filled
or
it's
been
canceled
or
it's
expired,
any
any
situation
where
that
reserve.
That
request
is
still
in
the
database.
A
B
A
So
first
I
wrote
the
query
to
get
the
reserves
data
and
then
I
thought
about
it.
I
said
I'm
also
going
to
want
the
data
from
old
reserves.
So
then
I
wrote
a
query
to
get
old
reserves
and
I
linked
them
together
and
then
I
thought
of
the
other
things
that
I
would
need,
and
then
I
added
some
refinements.
B
A
A
Because
I
have
this
question,
come
up
from
libraries
is
you
know
this
patron
wants
to
know?
You
know
I
want
to
know
about
this
request
that
a
patron
placed
what's
the
information
about
it.
So
this
way
I
can
use
this
report
to
say
you
know
the
request
was
placed
on
this
date.
It
expired
on
this
date,
there's
a
time
stamp
for
when
the
last
time
it
was
modified
and
here's
all
the
item
information.
A
A
A
A
A
You
can
use
a
union
query.
I've
got
another
example
here
that
I
won't
walk
through
the
steps
of
how
I
created
it.
But
let
me
just
run
this
one.
This
one
is
called
top
200
cirques
in
the
previous
year,
and
so
let's
just
pick
a
let's
pick
a
branch,
that's
going
to
have
a
decent
amount
of
circulation
and
let's
just
do
books,
leavenworth
books,
nonfiction,.
A
A
And
let
me
show
you
the
code
for
this,
so
the
union-
that's
in
here
is
the
same
thing.
I
needed
to
get
data
from
issues
and
from
old
issues,
and
so
I've
got
issues
and
old
issues
are
joined
here
and
that
creates
essentially
a
big
list
of
all
the
issues,
all
the
checkouts
and
then
the
rest
of
this
data.
B
I
find
those
unions
are
great
between
the
issues
and
the
reserves,
but
also
with
borrow
borrowers,
and
you
might
want
information
that
happens
that
happen
in
a
specific
time
period,
but
some
of
those
borrowers
or
items
or
issues
or
reserves.
Some
of
those
may
have
resolved
and
moved
to
another
table,
and
you
know
that's
where
it's
like
you're
getting
incomplete
information,
if
you're
not
using
union
to
to
combine
those
tables
to
get
a
complete
picture.
B
B
A
B
A
B
B
But
one
of
the
things
that
you
can
do
with
union
is
as
long
as
you
have
the
same
amount
of
columns,
you
can
put
information
into
a
report
that
has
nothing
to
do
with
the
the
previous
information,
so
you
can
have
results
of
two
different
reports
in
the
same
report.
They
have
nothing
to
do
with
each
other,
they're,
not
referencing,
the
same
information,
but
you
know,
as
long
as
you
have
the
same
amount
of
columns,
you
can
still
produce
that
information.
So
what
I've
done
here
is.
B
I
have
another
report
down
lower
that
is
totally
unrelated
to
the
information
above,
but
you
know
the
the
headings
up
above,
don't
match
what
I'm
reporting
down
here
below,
so
I've
I've
added
a
a
union
that
is
just
a
select
that
that
you
know
adds
some
lines
to
show.
This
is
something
different
and
then
I've
added
another
select.
That
is
just
some
static
information.
These
are
my.
B
B
This
last
month
that
I
did
here
it'll
take
a
minute
because
it
is
right,
it
is
pulling
a
lot
of
information,
but
the
nice
thing
is,
it
saves
me
so
much
time
having
to
run
a
report
enter
all
the
information,
run,
a
report
and
enter
all
the
information.
I
can
just
do
it
once,
which
is
really
nice
and
it'll
feed
back
all
of
this
information
that
I
need.
B
I
might
not
I'm
not
going
to
necessarily
put
everything
into
one
report,
because
I
don't
want
to
drag
the
system
down,
but
you
know
this.
This
will
give
me
a
good
chunk
of
it,
and
so
the
top
half
of
this
report
is
giving
me
back
results
but
based
on
library,
collection
and
the
type
of
information
that
it's
getting.
This
is
from.
B
I
believe
I
can't
remember
if
it's
from
the
stats
or
from
or
another
table
but
anyways,
it's
pulling
this
information
and
parsing
it
out
into
categories
that
I've
chosen.
But
then
here
are
my
dashes
down
below
it's
a
separator
for
breaking
off
into
something
else
and
here's
my
my
mocked,
headers
and
then
completely
different
information.
B
B
I
I
come
across
coalesce
once
or
twice,
but
I
had
never
thought
of
it
and
and
used
it
in
the
way
that
you
presented
and
it
was
like
it
really
opened
up
possibilities.
For
my
my
report.
Writing
you
know
I
I
feel
like
I
do
a
pretty
decent
job
with
reports,
but
this
gave
me
more
ammo
that
that
really
made
a
huge
difference.
B
A
B
A
A
A
A
B
Nice,
well,
I
love
it.
I
love
it
when
I
can
contribute
and
help
those
that
helped
me
and
you
you.
I
know
that
we've
collaborated
many
times
on
reports.
You've
done
a
tremendous
amount
of
work
that
I've
built
off
of
and
I'm
glad
to
see
that
some
of
my
work
is
coming
back
to
you.
So,
okay
awesome
all
right
well
until
next
time
next
time.
Thank
you
very
much.
We'll
see.
Y'all.