Data Query 2
-
I posted something just earlier regarding a similar issue. This isnt something I would normally have trouble with, as this is pretty basic data handling. However, I have another problem :( I am executing the following query:
SELECT * FROM Groups WHERE Group = 1on this table(Group being the primary key):Groups:
Group | In_Stock | On_Order_Short | On_Order_Long | Lead_Time
1 13 0 0 30
2 3 0 0 30
3 6 0 0 21
4 7 0 0 21
5 10 0 0 21
6 1 30 70 30It says there is a syntax error in my WHERE clause... It doesn't look like there is an error to me. Can anyone think of something that would be causing this :confused: It seems to only be doing it when I use "Group" in the WHERE clause, any other column it will work fine. Thanks again for any responses ;) -- modified at 22:10 Wednesday 26th April, 2006
-
I posted something just earlier regarding a similar issue. This isnt something I would normally have trouble with, as this is pretty basic data handling. However, I have another problem :( I am executing the following query:
SELECT * FROM Groups WHERE Group = 1on this table(Group being the primary key):Groups:
Group | In_Stock | On_Order_Short | On_Order_Long | Lead_Time
1 13 0 0 30
2 3 0 0 30
3 6 0 0 21
4 7 0 0 21
5 10 0 0 21
6 1 30 70 30It says there is a syntax error in my WHERE clause... It doesn't look like there is an error to me. Can anyone think of something that would be causing this :confused: It seems to only be doing it when I use "Group" in the WHERE clause, any other column it will work fine. Thanks again for any responses ;) -- modified at 22:10 Wednesday 26th April, 2006
Group is a sql keyword. Put braces around it it.
SELECT * FROM Groups WHERE [Group] = 1
-
Group is a sql keyword. Put braces around it it.
SELECT * FROM Groups WHERE [Group] = 1