i'm trying to run this query:
SELECT `communications.id` , `title` , `created` , `member` , CONCAT( `members.firstname` , ' ', `members.lastname` ) AS `member_name` , `communicationtypes.type` AS `type` , `notes`
FROM `communications` , `communicationtypes` , `members`
WHERE `communications.id` = '1' AND `communications.type` = `communicationtypes.id` AND `member` = `members.id`
which is a little complicated, but not too much so i thought. basically, if i run it as is it gives me a "unknown column" error for communications.id, despite the fact that there is an id colum in the communications table. if i change it to just 'id', then it gives me an 'id' is ambiguous error.
any ideas what the problem might be?
