Page 1 of 1
3. Given following tables: Name Pid Meier 1586 Mueller 1001 Schmidt 905 Join the tables using a (a) Natural-Join (b) Lef
Posted: Fri Jun 10, 2022 11:58 am
by correctanswer
- 3 Given Following Tables Name Pid Meier 1586 Mueller 1001 Schmidt 905 Join The Tables Using A A Natural Join B Lef 1 (115.46 KiB) Viewed 54 times
3. Given following tables: Name Pid Meier 1586 Mueller 1001 Schmidt 905 Join the tables using a (a) Natural-Join (b) Left-Outer-Join (c) Right-Outer-Join (d) Full-Outer-Join 4. Given following tables: Date Orders 02.09.03 Furniture 23.06.04 Vegetables 01.12.05 Pots 15.01.06 Cutlery Join the tables using (a) Equi-Join (Date=Date) (b) Theta-Join (Date>Date) (c) Semi-Join (x) Pid Salary 1586 4000 1235 2500 905 1000 512 1575 Date Value 02.09.03 4000€ 23.06.04 100€ 01.12.05 500€