The Ice Cream Shop 2

Retrieve data from Database (1:N:N relationship)

Order#	Name	Address	Credit Card	Flavors	Toppings

1	sam sultan	123 main street	visa	vanilla	hotFudge

1	sam sultan	123 main street	visa	chocolate	hotFudge

1	sam sultan	123 main street	visa	strawberry	hotFudge

1	sam sultan	123 main street	visa	vanilla	sprinkles

1	sam sultan	123 main street	visa	chocolate	sprinkles

1	sam sultan	123 main street	visa	strawberry	sprinkles

2	Sam Sultan	123 main blvd new york, new york	amex	strawberry	sprinkles

2	Sam Sultan	123 main blvd new york, new york	amex	butter-pecan	sprinkles

2	Sam Sultan	123 main blvd new york, new york	amex	strawberry	nuts

2	Sam Sultan	123 main blvd new york, new york	amex	butter-pecan	nuts

3	Sam Sultan	54321 some street Some Town, NY 12345	visa	vanilla	hotFudge

3	Sam Sultan	54321 some street Some Town, NY 12345	visa	chocolate	hotFudge

3	Sam Sultan	54321 some street Some Town, NY 12345	visa	vanilla	sprinkles

3	Sam Sultan	54321 some street Some Town, NY 12345	visa	chocolate	sprinkles

3	Sam Sultan	54321 some street Some Town, NY 12345	visa	vanilla	nuts

3	Sam Sultan	54321 some street Some Town, NY 12345	visa	chocolate	nuts

5	Sam Sultan	123 main street 12/10/12	visa	vanilla	hotFudge

5	Sam Sultan	123 main street 12/10/12	visa	chocolate	hotFudge

5	Sam Sultan	123 main street 12/10/12	visa	strawberry	hotFudge

5	Sam Sultan	123 main street 12/10/12	visa	vanilla	sprinkles

5	Sam Sultan	123 main street 12/10/12	visa	chocolate	sprinkles

5	Sam Sultan	123 main street 12/10/12	visa	strawberry	sprinkles

12	Saamahn Mahjouri	16392 Ringer Road	master-card	vanilla	hotFudge

13	hugh beard	testing 123	visa	vanilla	hotFudge

18	sam sultan	123 main street 2014-07-19	amex	vanilla	hotFudge

18	sam sultan	123 main street 2014-07-19	amex	chocolate	hotFudge

18	sam sultan	123 main street 2014-07-19	amex	strawberry	hotFudge

18	sam sultan	123 main street 2014-07-19	amex	vanilla	nuts

18	sam sultan	123 main street 2014-07-19	amex	chocolate	nuts

18	sam sultan	123 main street 2014-07-19	amex	strawberry	nuts

21	YANG CHEN	A good address	visa	chocolate	hotFudge

22	Yifei Han	145	master-card	vanilla	hotFudge

22	Yifei Han	145	master-card	strawberry	hotFudge

23	ying lian	888	visa	strawberry	hotFudge

23	ying lian	888	visa	butter-pecan	hotFudge

2524	Sam Sultan	123 Main Street	visa	vanilla	hotFudge

2524	Sam Sultan	123 Main Street	visa	chocolate	hotFudge

2524	Sam Sultan	123 Main Street	visa	strawberry	hotFudge

2524	Sam Sultan	123 Main Street	visa	vanilla	sprinkles

2524	Sam Sultan	123 Main Street	visa	chocolate	sprinkles

2524	Sam Sultan	123 Main Street	visa	strawberry	sprinkles

2525	Sam Sultan	123 Main Street	master-card	vanilla	nuts

2525	Sam Sultan	123 Main Street	master-card	butter-pecan	nuts

2525	Sam Sultan	123 Main Street	master-card	vanilla	whippedCream

2525	Sam Sultan	123 Main Street	master-card	butter-pecan	whippedCream

2526	Sam Sultan	AAA street New York	visa	vanilla	hotFudge

2526	Sam Sultan	AAA street New York	visa	chocolate	hotFudge

2526	Sam Sultan	AAA street New York	visa	strawberry	hotFudge

2526	Sam Sultan	AAA street New York	visa	vanilla	sprinkles

2526	Sam Sultan	AAA street New York	visa	chocolate	sprinkles

2526	Sam Sultan	AAA street New York	visa	strawberry	sprinkles

2527	Sam Sultan	111 main street	visa	vanilla	hotFudge

2527	Sam Sultan	111 main street	visa	chocolate	hotFudge

2527	Sam Sultan	111 main street	visa	strawberry	hotFudge

2527	Sam Sultan	111 main street	visa	vanilla	sprinkles

2527	Sam Sultan	111 main street	visa	chocolate	sprinkles

2527	Sam Sultan	111 main street	visa	strawberry	sprinkles

2528	Sam Sultan	123 Main Street	amex	rocky-road	hotFudge

2528	Sam Sultan	123 Main Street	amex	french-vanilla	hotFudge

2528	Sam Sultan	123 Main Street	amex	pistachio	hotFudge

2528	Sam Sultan	123 Main Street	amex	rocky-road	nuts

2528	Sam Sultan	123 Main Street	amex	french-vanilla	nuts

2528	Sam Sultan	123 Main Street	amex	pistachio	nuts

2529	Sam Sultan	123 Main Street	visa	vanilla	hotFudge

2530	Sam Sultan	123 Main Street	visa	vanilla	hotFudge

2531	Sam Sultan	123 Main Street	visa	vanilla	hotFudge

2531	Sam Sultan	123 Main Street	visa	chocolate	hotFudge

2531	Sam Sultan	123 Main Street	visa	strawberry	hotFudge

2531	Sam Sultan	123 Main Street	visa	vanilla	sprinkles

2531	Sam Sultan	123 Main Street	visa	chocolate	sprinkles

2531	Sam Sultan	123 Main Street	visa	strawberry	sprinkles

2532	Sam Sultan	123 Main Street	visa	chocolate	hotFudge

2533	Sam Sultan	123 Main Street	visa	vanilla	hotFudge

2533	Sam Sultan	123 Main Street	visa	chocolate	hotFudge

2534	Sam Sultan	123 Main Street	visa	vanilla	hotFudge

2534	Sam Sultan	123 Main Street	visa	chocolate	hotFudge

2535	Sam Sultan	1234 Main Street	visa	vanilla	hotFudge

2535	Sam Sultan	1234 Main Street	visa	chocolate	hotFudge

2536	Sam Sultan	1234 Main Street	visa	vanilla	hotFudge

2536	Sam Sultan	1234 Main Street	visa	butter-pecan	hotFudge

2536	Sam Sultan	1234 Main Street	visa	rocky-road	hotFudge

2537	Sam Sultan	1234 Main Street	amex	vanilla	hotFudge

2538	Samuel Sultan	123-456 Main Street	visa	vanilla	hotFudge

2538	Samuel Sultan	123-456 Main Street	visa	chocolate	hotFudge

2538	Samuel Sultan	123-456 Main Street	visa	strawberry	hotFudge

2548	Samuel Sultan	1234 Main Street	visa	vanilla	hotFudge

2548	Samuel Sultan	1234 Main Street	visa	chocolate	hotFudge

2548	Samuel Sultan	1234 Main Street	visa	strawberry	hotFudge

2548	Samuel Sultan	1234 Main Street	visa	vanilla	sprinkles

2548	Samuel Sultan	1234 Main Street	visa	chocolate	sprinkles

2548	Samuel Sultan	1234 Main Street	visa	strawberry	sprinkles

2560	Samuel Sultan	1234 Main Street	visa	vanilla	hotFudge

2560	Samuel Sultan	1234 Main Street	visa	chocolate	hotFudge

2560	Samuel Sultan	1234 Main Street	visa	strawberry	hotFudge

2560	Samuel Sultan	1234 Main Street	visa	vanilla	sprinkles

2560	Samuel Sultan	1234 Main Street	visa	chocolate	sprinkles

2560	Samuel Sultan	1234 Main Street	visa	strawberry	sprinkles

2566	Sam Sultan	1234 Main Street	visa	Vanilla	Hot Fudge

2566	Sam Sultan	1234 Main Street	visa	Chocolate	Hot Fudge

2566	Sam Sultan	1234 Main Street	visa	Strawberry	Hot Fudge

2566	Sam Sultan	1234 Main Street	visa	Rocky Road	Hot Fudge

2566	Sam Sultan	1234 Main Street	visa	French Vanilla	Hot Fudge

2566	Sam Sultan	1234 Main Street	visa	Vanilla	Sprinkles

2566	Sam Sultan	1234 Main Street	visa	Chocolate	Sprinkles

2566	Sam Sultan	1234 Main Street	visa	Strawberry	Sprinkles

2566	Sam Sultan	1234 Main Street	visa	Rocky Road	Sprinkles

2566	Sam Sultan	1234 Main Street	visa	French Vanilla	Sprinkles

2567	Sam Sultan	1234 Main Street	visa	Butter Pecan	Hot Fudge

2567	Sam Sultan	1234 Main Street	visa	Rocky Road	Hot Fudge

2567	Sam Sultan	1234 Main Street	visa	French vanilla	Hot Fudge

2568	Sam Sultan	1234 Main Street	master-card	Chocolate	Hot Fudge

2568	Sam Sultan	1234 Main Street	master-card	Chocolate Chip	Hot Fudge

2571	di gou	123mainst	visa	Vanilla	Hot Fudge

2571	di gou	123mainst	visa	Butter Pecan	Hot Fudge

2571	di gou	123mainst	visa	Pistachio	Hot Fudge

2571	di gou	123mainst	visa	Vanilla	Whipped Cream

2571	di gou	123mainst	visa	Butter Pecan	Whipped Cream

2571	di gou	123mainst	visa	Pistachio	Whipped Cream

2573	frank zhang	2222	visa	Vanilla	Hot Fudge

2574	Sam Sultan	1234 Main Street	visa	Vanilla	Sprinkles

2577	Zac Efron	123 Hollywood Lane	amex	vanilla	sprinkles

2577	Zac Efron	123 Hollywood Lane	amex	vanilla	whippedCream

2578	h a	b	master-card	chocolate	hotFudge

Click to see the [code]