Giventhefollowingtwotables: TAB1C1C2 A11B12C13TAB2CXCY A21C22D23 Thefollowingresultsaredesired: C1C2CXCY A11A21C13C22----D23 Whichofthefollowingquerieswillyieldthedesiredresults?() A: SELECT*FROMtab1INNERJOINtab2ONc1=cx B: SELECT*FROMtab1LEFTOUTERJOINtab2ONc1=cx C: SELECT*FROMtab1FULLOUTERJOINtab2ONc1=cx D: SELECT*FROMtab1RIGHTOUTERJOINtab2ONc1=cx
Giventhefollowingtwotables: TAB1C1C2 A11B12C13TAB2CXCY A21C22D23 Thefollowingresultsaredesired: C1C2CXCY A11A21C13C22----D23 Whichofthefollowingquerieswillyieldthedesiredresults?() A: SELECT*FROMtab1INNERJOINtab2ONc1=cx B: SELECT*FROMtab1LEFTOUTERJOINtab2ONc1=cx C: SELECT*FROMtab1FULLOUTERJOINtab2ONc1=cx D: SELECT*FROMtab1RIGHTOUTERJOINtab2ONc1=cx
1