i'm ok taxes 2013 shoot or ooze
in this video we will be creating another union query
as you did in the previous video I'm so gonna play along
funny imploded on a section website on the next 20-30
DB 46 in a note from that but put up
login with password okay in previous video
said recreates its query booking extra charges Union
and we're gonna be crackin other union carried a scanner
union this and a select query and the reason we wanna do you guys you wanna
put
all the charges which is basically what this is alongside
who love the payments which is here today which I hit a limb was payments
hocker
alright so were disclosed that nets
closed I Post Oak Creek
creed is eyeing and we need
table ambushed payments for the moment miss a thing
term for a given age you
in which case in which side the dress code for table in police
your booking ID we do your booking ID
your payment eight-week to weekend amount as well
chasers go for I'll
clicking here and
longer to do is ludicrous cram their creative juices as well
got a builder and coldest
booking high-t_ semicolon he cools
table invoices dot
King I DSK so leverage is taking
the filter is booking ID underscore escapes foreign key table invoices and
run it splendid booking ID
a.m. next thing we want is d
day now I cannot realistically
payment a on change the field so mccauley Swan
trends action day she's
table invoice payments doc a
payment date so again we've got
that I'm
K next thing
is I just want dished extra column on its next column to say payment so only
for
quite certain and then
and quotation marks payment cipher run that
who dis repeat payment down and
amount paid this just
a.m. who dis one amount she's
table invoice payment talk amount paid
so came from that okay
you pretty good now if we open up the query we made in the previous video
we had the the ID we had today
Brett texting where the charge and this one we've got
the ID to take some texans charge so there that means we can actually put
them together
so what we now wanna to
is I am we sing
Minister create
curry design can we just want
queries we won't weary you can trust you next charges
now
sign could ask your views here to gonna take
selects a min takeover query one
prevent SQL View Lee
semi code on and its union cool
has to turn control V Nonna
for their work together now again we want to order by transaction day
so perfect SQL View to get something so long
and order by and
table well strike transaction date
process and work give it a go
has it worked it worked has indeed worked
has indeed world excellent and
so to save that cooler one weary
costs payments
Union
hope Kb so yep that's that list carrot Creek second-grader it anymore
anger that on alrighty
a.m. yessir so you can create union query using another union query
to might be slightly more sophisticated way of doing that bob for doing it like
this
taking the a.m.
select think revoking extras union because then if I need to make a change
to
anything in this part the query I don't actually need to do anything to square
just go
query cost payments Union some popular consul separating out
so I'm for that reason I would prefer to do it like this
a.m. and I said death us that so we've got essentially
all of the information and that we need so your sis
my phone hang around okay britt in thank you for watching a she see you
in next video