1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

[SQL] I face a problem in sql "could not be a bound"

Discussão em 'Outras Linguagens' iniciado por Stack, Agosto 4, 2021.

  1. Stack

    Stack Membro Participativo

    I face a problem in the SQL Server in a command which shows the error "Could not be a bound".

    select part.date as Partial_date, part.location as partial_Location
    union
    select fully.date as full_date,fully.location as full_Location, people_vaccinated, people_fully_vaccinated
    from dbo.Partial_vaccinated part
    full outer join dbo.full_vaccinated fully on part.date=fully.date and part.location = fully.location


    It shows error at part.date and part.location. Can anyone solve this? Here I need to put a union between two-column of different tables which already contain outer join

    table1
    Date location vaccinated
    2021-05-14 Turkey 14814316
    2021-05-14 Ukraine 936497
    2021-05-15 Finland 2105016

    Table 2
    Date location fully_vaccinated
    2021-05-14 Turkey 2941
    2021-05-15 Qatar 824293

    final table
    Date location vaccinated fully_vaccinated
    2021-05-14 Turkey 14814316 2941
    2021-05-14 Ukraine 936497 Null
    2021-05-15 Qatar Null 824293
    2021-05-15 Finland 2105016 Null

    Continue reading...

Compartilhe esta Página