Як виправити Сообщение 102, уровень 15, состояние 1, строка 2 Incorrect syntax near '.'.

murka 0

SELECT Student.FirstName, Student.LastName, Student.Surname,[Group].NameGroup

Stat.NameStat

FROM Student, Stat [Group]

WHERE Student.StatID = Stat.ID AND Stat.NameStat = 'Жінка'

AND Student.GroupID = [Group].ID AND [Group].NameGroup = 'IT-31'

Hui Liu-MSFT 48,531 Reputation points Microsoft Vendor

2024-03-20T06:46:52.7466667+00:00
Hi,@murka. Welcome to Microsoft Q&A.

If you have any questions, you could share and communicate with the community here instead of via email. By the way, this is an English forum.

The correct syntax for selecting columns from multiple tables with aliases in SQL is to separate each column name with a comma (','). Additionally, table aliases should be followed by a period ('.') before the column name.

SELECT Student.FirstName, Student.LastName, Student.Surname, [Group].NameGroup, Stat.NameStat FROM Student, Stat, [Group] WHERE Student.StatID = Stat.ID AND Stat.NameStat = 'Жінка' AND Student.GroupID = [Group].ID AND [Group].NameGroup = 'IT-31'

I added a comma between Stat.NameStat and [Group].NameGroup in the SELECT clause.

I also added the Stat table to the FROM clause so that it is properly included in the query.

If the problem persists, please share the error message and more details with me.
Hui Liu-MSFT 48,531 Reputation points Microsoft Vendor

2024-03-22T06:28:02.43+00:00

Hi,@murka.Is there any update to the question? Has your problem been solved? Did my solution help you?

1 answer