1
00:00:00,780 --> 00:00:03,070
lol ok taxes 2013 she two rooms

2
00:00:03,069 --> 00:00:06,599
still young can explain to you what the cartesian product is

3
00:00:06,599 --> 00:00:09,800
need this to you tree the

4
00:00:09,800 --> 00:00:13,320
booking should we have been creating

5
00:00:13,320 --> 00:00:18,929
so you gonna play along full England video to on the sexual sin taxes 2013

6
00:00:18,929 --> 00:00:25,929
DV 57 Canada

7
00:00:28,010 --> 00:00:30,670
okay site

8
00:00:30,670 --> 00:00:34,050
this is taking a look what we were doing or we might need

9
00:00:34,049 --> 00:00:38,058
strategic product we demonstrate should inform

10
00:00:38,058 --> 00:00:41,500
dates top and we can at

11
00:00:41,500 --> 00:00:45,079
text books isn't here which correspond to each day

12
00:00:45,079 --> 00:00:48,899
in Aus a question on the actual table 2001

13
00:00:48,899 --> 00:00:52,179
was our guest I'm going to use D look up to determine

14
00:00:52,179 --> 00:00:55,939
and Adina Cup skinny need to look up for Record

15
00:00:55,939 --> 00:01:01,238
in clear enough to record exists and its gonna say it is guest

16
00:01:01,238 --> 00:01:04,759
doesn't exist work simply right from

17
00:01:04,760 --> 00:01:08,109
go his booking

18
00:01:08,109 --> 00:01:12,250
details doesn't stall one record per day

19
00:01:12,250 --> 00:01:16,900
is just one record time period so we need to

20
00:01:16,900 --> 00:01:19,909
is called unit exploded stable

21
00:01:19,909 --> 00:01:24,229
now that's as much as I'm gonna tell you go why we need to do this

22
00:01:24,228 --> 00:01:28,959
I'm stop by folks in on what they call teaching product is which is the first

23
00:01:28,959 --> 00:01:29,529
step

24
00:01:29,530 --> 00:01:32,540
okay so she go to create

25
00:01:32,540 --> 00:01:36,090
click link for design and

26
00:01:36,090 --> 00:01:40,539
costs you use realistic booking details

27
00:01:40,539 --> 00:01:43,689
begin to take okay

28
00:01:43,688 --> 00:01:48,008
so 3 typically at table

29
00:01:48,009 --> 00:01:51,530
into query week mister

30
00:01:51,530 --> 00:01:54,789
records first run

31
00:01:54,789 --> 00:01:58,248
oversee we get every single Road

32
00:01:58,248 --> 00:02:01,818
every single record returned stern districts in fact she places

33
00:02:01,819 --> 00:02:06,429
funny taken three shields now free then

34
00:02:06,429 --> 00:02:09,909
and say table bookings in

35
00:02:09,909 --> 00:02:14,799
before joining and then fired booking

36
00:02:14,800 --> 00:02:18,469
day here Chris Brown what we do

37
00:02:18,469 --> 00:02:23,969
he's we get every single record from both tables with a recall which means

38
00:02:23,969 --> 00:02:27,740
sir record in table bookings

39
00:02:27,740 --> 00:02:32,140
Chevrolet as it's one too many be unused looking mighty

40
00:02:32,139 --> 00:02:35,179
its work every single record

41
00:02:35,180 --> 00:02:39,520
where we go booking ID SKN take booking details now as it happens every single

42
00:02:39,520 --> 00:02:40,390
record in time

43
00:02:40,389 --> 00:02:45,269
details has looking I D S case we get every single record back

44
00:02:45,270 --> 00:02:49,280
but there has been a restriction placed on that and

45
00:02:49,280 --> 00:02:53,710
an ass and nature joins and in mathematical terms is to do

46
00:02:53,710 --> 00:02:56,780
sets not be on its way too much rather

47
00:02:56,780 --> 00:03:00,789
now what happens ish we get rid table bookings

48
00:03:00,789 --> 00:03:04,269
and we showed

49
00:03:04,270 --> 00:03:10,120
see Table its for you from Cherie

50
00:03:10,120 --> 00:03:14,670
re: to record in Table force obviously they've got nothing to do

51
00:03:14,669 --> 00:03:18,500
each other really what would happen if you use

52
00:03:18,500 --> 00:03:23,379
table for some don't rejoice records we get we get

53
00:03:23,379 --> 00:03:26,400
28 rickles so what do we get

54
00:03:26,400 --> 00:03:30,950
28 records well when we don't create a joint between two tables

55
00:03:30,949 --> 00:03:35,310
in access what does it takes every single recall from one table

56
00:03:35,310 --> 00:03:38,729
and multiplies by every single record from the other table

57
00:03:38,729 --> 00:03:42,019
so if I were to

58
00:03:42,020 --> 00:03:45,310
school sending officials acted

59
00:03:45,310 --> 00:03:50,280
members only two records in table for some forecasts activity

60
00:03:50,280 --> 00:03:54,189
and report summary and everything here

61
00:03:54,189 --> 00:03:57,719
is porque es activity

62
00:03:57,719 --> 00:04:03,189
mixed we've every single records from table booking details

63
00:04:03,189 --> 00:04:07,770
so 10 Oct to oversee

64
00:04:07,770 --> 00:04:13,510
not in the correct order action this morning

65
00:04:13,509 --> 00:04:20,509
10 min just 10 sting shift

66
00:04:21,639 --> 00:04:24,569
let's johnnie could missus arsonist largest

67
00:04:24,569 --> 00:04:29,180
echoed

68
00:04:29,180 --> 00:04:32,579
so miss me and then

69
00:04:32,579 --> 00:04:36,529
to ok

70
00:04:36,529 --> 00:04:41,059
right now you're okay sorry for guest activity goes from

71
00:04:41,060 --> 00:04:44,490
book an ID details Sharia 16

72
00:04:44,490 --> 00:04:48,579
and we can also see focus some reason exactly the same thing

73
00:04:48,579 --> 00:04:52,329
the candy suree 16 show is literally

74
00:04:52,329 --> 00:04:56,129
taken listen every single for table booking details more flooded by

75
00:04:56,129 --> 00:04:56,990
everything from

76
00:04:56,990 --> 00:05:00,650
table report 9 saddam as 28 records

77
00:05:00,649 --> 00:05:03,929
quick question how many records the thing that would be if we added

78
00:05:03,930 --> 00:05:07,228
a.m. another recalled in to you

79
00:05:07,228 --> 00:05:12,538
table reports 21

80
00:05:12,538 --> 00:05:16,930
shows 42 you would be correct because if we added another record

81
00:05:16,930 --> 00:05:20,060
you just three records in Table ports

82
00:05:20,060 --> 00:05:23,918
which be multiplied by 14 records in table booking details

83
00:05:23,918 --> 00:05:27,448
and three times for teens 42 and

84
00:05:27,449 --> 00:05:31,500
this is the wakes vision products work am lot of using this is a park

85
00:05:31,500 --> 00:05:36,439
it really is in the bug is actually has its origins in the way in which

86
00:05:36,439 --> 00:05:38,060
Structured Query Language

87
00:05:38,060 --> 00:05:41,288
originated Bates kinda useful and

88
00:05:41,288 --> 00:05:45,310
and in the coming top videos show you how useful is

89
00:05:45,310 --> 00:05:49,189
if you're still a little bit confused about it Google cartesian product

90
00:05:49,189 --> 00:05:55,158
I am SQL we've just got Ian product will give you the information you need

91
00:05:55,158 --> 00:05:58,699
a.m. and yeah that's it so now we've looked at

92
00:05:58,699 --> 00:06:00,530
I shall see you in the next video