• 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

    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