Is this right? ( JOIN )

Hello,

My query is as follows:

SELECT * FROM `{$dbprefix}multi_admins` 
	          WHERE `id` = '".clean_up($_SESSION['id'])."'
			  JOIN `{$dbprefix}multi_permissions` 
			  ON `{$dbprefix}multi_admins.id` = `{$dbprefix}multi_permissions.admin_id`

Code (markup):

Is there anything visually wrong with it? In my PHP file its giving mysql errors.

If i just use the simple select from that single file, it works. Just when i add the join i get

(This is more related to SQL than php?)
Thanks.

 

What are you trying to do?

 

Never mind, the guys over at phpfreaks fixed it. I had a few ` in the wrong place and some over stuff.. .

SELECT * FROM `multi_admins`
           INNER JOIN `multi_permissions`
           ON `multi_admins`.id = `multi_permissions`.admin_id
           WHERE `multi_admins`.id = '" . clean_up($_SESSION['id']) . "'

Code (markup):