ORA-00904 Invalid Identifier

[FireGeek21]

I have the following SQL Expression that works just fine:

(SELECT "PGEMPLOYEE"."GROUP_NAME"
FROM "LAWSON"."PGEMPLOYEE" "PGEMPLOYEE"
WHERE ("PGEMPLOYEE"."GROUP_NAME"='MRALIST1-O'
OR "PGEMPLOYEE"."GROUP_NAME"='MRALIST2-O')
AND "PGEMPLOYEE"."COMPANY" = "EMPLOYEE"."COMPANY"
AND "PGEMPLOYEE"."EMPLOYEE" = "EMPLOYEE"."EMPLOYEE")

However... I actually need a list of employees to look through so selecting "PGEMPLOYEE"."EMPLOYEE" is better suited for this. I changed this out and now the following is not working at all!

(SELECT "PGEMPLOYEE"."EMPLOYEE"
FROM "LAWSON"."PGEMPLOYEE" "PGEMPLOYEE"
WHERE ("PGEMPLOYEE"."GROUP_NAME"='MRALIST1-O'
OR "PGEMPLOYEE"."GROUP_NAME"='MRALIST2-O')
AND "PGEMPLOYEE"."COMPANY" = "EMPLOYEE"."COMPANY"
AND "PGEMPLOYEE"."EMPLOYEE" = "EMPLOYEE"."EMPLOYEE")

Any ideas??? Thanks!

FireGeek21

FireGeek
(currently using Crystal Reports XI with Lawson 9.01)