Help with Query

[vingne]

SELECT * FROM Ugroup_Members WHERE ugp_id=1

i want also it to be WHERE ugm_role=2

how is this possible?

(in my head: SELECT * FROM Ugroup_Members WHERE ugp_id=1 AND WHERE ugm_role=2 )

[vingne]

figured out myself, had to drop the WHERE after AND :)