[SQL] Join On - correct syntax?

[Tristan Perry]

Hey all,
I've been trying to get better at SQL queries (I suck at them!) but have hit a little bump. I can't seem to get JOIN SQL queries to work. The following works:

Code Select Expand

SELECT jokes.Name, jokes.Joke, jokes.Activated, jokecat.Name
FROM jokes, jokeCat
WHERE jokes.MemberID = '1'
AND jokes.CategoryIn = jokecat.ID

but this doesn't:

Code Select Expand

SELECT jokes.Name, jokes.Joke, jokes.Activated, jokecat.Name
FROM jokes, jokeCat
WHERE jokes.MemberID='1'
JOIN jokecat
ON jokes.CategoryIn=jokecat.ID

Any ideas why and help would be greatly appreciated
Thanks,
Tau Online

[Remaker]

try this 

Code Select Expand


SELECT jokes.Name, jokes.Joke, jokes.Activated, jokecat.Name
FROM jokes, jokeCat
JOIN jokecat ON jokes.MemberID='1' AND jokes.CategoryIn=jokecat.ID


[Tony Reid]

I found this (FREE) visual query tool a great help when starting out with queries.

http://crlab.com/mybuilder/

You may need to download .net framework (if your not running XP sp2)- but they provide a link.

They also do another product for $49 which has that tool built in + others
http://crlab.com/mysqldev/

[Tristan Perry]

try this 

Code Select Expand


SELECT jokes.Name, jokes.Joke, jokes.Activated, jokecat.Name
FROM jokes, jokeCat
JOIN jokecat ON jokes.MemberID='1' AND jokes.CategoryIn=jokecat.ID


Thanks for that, although it gives the error "Not unique table/alias: 'jokecat'"?

I found this (FREE) visual query tool a great help when starting out with queries.

http://crlab.com/mybuilder/

You may need to download .net framework (if your not running XP sp2)- but they provide a link.

They also do another product for $49 which has that tool built in + others
http://crlab.com/mysqldev/

Ah that should be very helpful, thanks