[RESOLVED] Joining two mysql tables...

[wpearsall]

ok guys...

SELECT r_category.catid, r_category.title,
r_business.name, r_business.address, r_business.emailcontact 
FROM r_business 
FULL OUTER JOIN r_category ON r_business.catid = r_category.catid 
WHERE r_business.BusinessID=2

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OUTER JOIN r_category ON r_business.catid = r_category.catid WHERE r_business.Bu' at line 1.

ok gues... heres my problem, i have got two tables,, r_business, and r_category

r_category lists diff categorys of business (restaurant / hotel ETC) n links via catid in both tables.

HOW can i get the information in one query... i only wanna select a certain business?.... i thought that was correct but guess not... any help please?