Skip to content

Wrong syntax in mysql #1

Description

@Wind213
SELECT
  `Task`.`Id`              AS `id`,
  `Task`.`Description`     AS `description`,
  `Task`.`Done`            AS `done`,
  `Task`.`TaskTypeId`      AS `taskTypeId`,
  `Task`.`UserId`          AS `userId`,
  `taskType`.`Id`          AS `taskType.id`,
  `taskType`.`Description` AS `taskType.description`
FROM `tenant_1.Tasks` AS `Task` LEFT OUTER JOIN `shared.TaskTypes` AS `taskType`
    ON `Task`.`TaskTypeId` = `taskType`.`Id`
WHERE `Task`.`UserId` = 1;

Can you help me with this problem ?
I'm using MariaDB

FROM tenant_1.Tasks AS ...
in MariaDB is a wrong syntax. how to change it into tenant_1.Tasks.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions