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

Question

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,711 Reputation points Microsoft External Staff

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,711 Reputation points Microsoft External Staff

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

Hui Liu-MSFT 48,711 Reputation points Microsoft External Staff

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,711 Reputation points Microsoft External Staff

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?

Answer 1

Olaf Helper 47,586

FROM Student, Stat [Group]

Is there a komma missing between the two table names Stat and Group? So [GROUP] acts as an object alias.

murka 0 Reputation points

2024-03-18T12:37:18.7933333+00:00

Напишіть мені правильний код+
Olaf Helper 47,586 Reputation points

2024-03-18T12:56:07.1533333+00:00

This is an English spoken forum, so please post in English.