lol ok taxes 2013 she two rooms
still young can explain to you what the cartesian product is
need this to you tree the
booking should we have been creating
so you gonna play along full England video to on the sexual sin taxes 2013
DV 57 Canada
okay site
this is taking a look what we were doing or we might need
strategic product we demonstrate should inform
dates top and we can at
text books isn't here which correspond to each day
in Aus a question on the actual table 2001
was our guest I'm going to use D look up to determine
and Adina Cup skinny need to look up for Record
in clear enough to record exists and its gonna say it is guest
doesn't exist work simply right from
go his booking
details doesn't stall one record per day
is just one record time period so we need to
is called unit exploded stable
now that's as much as I'm gonna tell you go why we need to do this
I'm stop by folks in on what they call teaching product is which is the first
step
okay so she go to create
click link for design and
costs you use realistic booking details
begin to take okay
so 3 typically at table
into query week mister
records first run
oversee we get every single Road
every single record returned stern districts in fact she places
funny taken three shields now free then
and say table bookings in
before joining and then fired booking
day here Chris Brown what we do
he's we get every single record from both tables with a recall which means
sir record in table bookings
Chevrolet as it's one too many be unused looking mighty
its work every single record
where we go booking ID SKN take booking details now as it happens every single
record in time
details has looking I D S case we get every single record back
but there has been a restriction placed on that and
an ass and nature joins and in mathematical terms is to do
sets not be on its way too much rather
now what happens ish we get rid table bookings
and we showed
see Table its for you from Cherie
re: to record in Table force obviously they've got nothing to do
each other really what would happen if you use
table for some don't rejoice records we get we get
28 rickles so what do we get
28 records well when we don't create a joint between two tables
in access what does it takes every single recall from one table
and multiplies by every single record from the other table
so if I were to
school sending officials acted
members only two records in table for some forecasts activity
and report summary and everything here
is porque es activity
mixed we've every single records from table booking details
so 10 Oct to oversee
not in the correct order action this morning
10 min just 10 sting shift
let's johnnie could missus arsonist largest
echoed
so miss me and then
to ok
right now you're okay sorry for guest activity goes from
book an ID details Sharia 16
and we can also see focus some reason exactly the same thing
the candy suree 16 show is literally
taken listen every single for table booking details more flooded by
everything from
table report 9 saddam as 28 records
quick question how many records the thing that would be if we added
a.m. another recalled in to you
table reports 21
shows 42 you would be correct because if we added another record
you just three records in Table ports
which be multiplied by 14 records in table booking details
and three times for teens 42 and
this is the wakes vision products work am lot of using this is a park
it really is in the bug is actually has its origins in the way in which
Structured Query Language
originated Bates kinda useful and
and in the coming top videos show you how useful is
if you're still a little bit confused about it Google cartesian product
I am SQL we've just got Ian product will give you the information you need
a.m. and yeah that's it so now we've looked at
I shall see you in the next video