inner join problem
hey Ray
Am trying to do an inner join so that I can use the CategoryName from this table: http://prntscr.com/hackii in this select statement
SELECT * FROM sponsors ORDER BY SponsorName ASC
but cannot get it to work.
I have tried
SELECT sponsors.*, sponsorcategories.* FROM sponsors INNER JOIN sponsorcategories ON sponsors.SponsorID = sponsorcategories.CategoryID ORDER BY sponsors.SponsorName ASC
but this doesnt return all the records and the ones it does have the wrong CategoryName associated with them
Cheers
Jamie