along x-axis 2013 tutorials
in this video I'm gonna be creating
the lookup table we're gonna need for the showed uniform
and site from a play along for the link below the video to dissection website
and on alexis 2013 TV 58
nope
a gay first things first issues
sheeps if you
have in sports the last video Anya
she greeting me to discuss Cartesian products
I am he's very quick reminder for trying to do
we're trying to use create a table
that list a booking actually
records for booking details should say so that we're able to ask simple
question
for example on the night shift October in room 201
was fair is there guest thing
and we're gonna have corresponding text boxes on each other records
here again for the information in there
I'm another challenge we have is
the should table booking details we have
range of dates so she's on the list
bookings in the 16th July into the 19th
August and we've tried to recreate some kinda complicated lookup functioned
mix-up the date within that date range
a.m. but it's gonna be really complicated can be a pain to
maintain if there's any issues after testes headache so fresh you trying to
use
try and take take booking details and we're gonna
school exploded stable so that you end up with
one record per day and this is where the torch los TX are going to use
cartesian product to do that so St right now
gonna go to create for design a Mesa table early I'm inquiry were trying to
trick weary
week Information Office minister table takes in there
table takes if you don't know
is a table with every single day
from the first is January 2007 cool to wear
sues the training I actually from 2027
you stop so
let us interested really in
open takes an LNG day a.m.
now for a run that we get
who revels in the world I'm interested in records
and whatever more interested in find solutions
on is really really interested in explode and he takes between
the first a in the surgeon the law states the first days and nights in
time lost ace 23rd October so immediately the first thing you want to
do
strict we don't display 07424 records when you honestly 40
so it wasn't a layer of you when the shitter
loads up lines with its
this temp stop here loading up hansel
into she's attempt and a scroll to the bottom
said Tim very cool
so she can
Ste and
temp and take and it's going to be
to
stand
as a sequel to you start date just
10 stop temp and going to use them to restrict
the values in this
she foresees close its
very thank you cake maybe go
say and Angie day must be greater than or equal to
Tim us temps
me and
must be less than or equal to
to us 10
and dokie
yes dates you go says he saved us right now
cleary Kings
pics loader okay
I'm going to use a concept to the cartesian product now work in a creek
separate day to say
I'm not gonna lick the dates to it so we're gonna
and shooting booking details bookings guests
and rims this these full
times LinkedIn sense to be one day to set and anything we pull from these
tables
multiplied records in Table dates
so us missed due to Gita
teacher the shaking the checkout
guessed it: you know
from my GV so actually name to the guest
so cast
best Kong cat a nation table guests
first name amps its
last night cakes remember
we have 210 rickles
Street Suite 210 records is table dates
is returning 14 records
believe may be shifting and is multiplying it by the records
be returned here and records be returned here actually
40 so 14 time something is 210
just went on sixty okay see Table de ses you turn in 15 records in its
just a sister turned 14 the most fun together
so the moment as you can see
checking take 15 for July check out that ninety-five August
date tonight serve October
so this first set is booking details
multiplied by the knife October the second was on booking details marked by
the temple time
which is good except reaction I wanna make a restriction because
if the state here doesn't full VIN checkin checkout date
should be there so we gonna place instruction on that criteria
asking me to check in date must be
less than or equal to
table take
stock take she's and
check act check-out date must be greater than or equal to you
table takes dates number I
we get nothing just completely correct reasons completely correct his
there's nothing in the booking details actually falls in this time period
today's night over so
exchange these much
them sing term
and Creek
news
to sure easy ship
cases three if the
booking details for women range now to be close to
process life nothing happens amazing
30 re huge
and either okay so
me 45 records an example recalled
is the nice for type
every single booking details falls on my October
showing fact to leave the bookings
full dates so you're the date ranges 22 July 2 21st December
so that's clearly the National times within that
another date range be the third is
over to the 24th time that falls within that exploded every single
record in D booking details tabled
schools have been the day range okay work to shine Eunice
tutorial is at least
a little bit complicated and Tennessee I do using a cartesian product to explode
the records I'm best thing to do
disease complicated makes banging head against a wall video see a sea change in
its watch the video again
to you've got table dates which you can
a.m. get into any database you make
external data comports maxine bring in table base in there
the technique is here it's a bit confusing
as long as you make sure to use trick debates been shown foresees an induction
seven thousand days
and then just to make sure that use it whenever their stock places
he said it to be less than or equal to take some whatever the
and a has to be greater than today's am
I hesitate to say simple as that it's one of those things you can have to
watch it a few times I guarantee you if we truly understand it and
yes their rights is how to tree exploding picking
and I sure hope to see you next video