[PHP] Mysql Query Help needed

I have a query select cust_fnn, cust_name, agroup_access.group_access_cust from cust, agroup_access where agroup_access.group_access_group='$id' cust.cust_fnn!=agroup_access.group_access_cust order by cust.cust_name The 2 tables are as follows agroup_access agroup_access_id

RE: [PHP] Mysql Query Help needed

[snip] select cust_fnn, cust_name, agroup_access.group_access_cust from cust, agroup_access where agroup_access.group_access_group='$id' cust.cust_fnn!=agroup_access.group_access_cust order by cust.cust_name [/snip] try this (note syntactical differences); select cust_fnn, cust_name,