• 2022-05-31
    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