mySQL syntax problems

TeKBuzz · Share | #1 (**permalink**) 03-07-2005, 01:13 PM

Ok, I haven't done mysql in a while and someone will yell at me for not realizing why this is wrong but...

Code:

SELECT * FROM 
games AS g, 
game_types AS gt, 
publishers AS p, 
developers AS d
WHERE 
g.id_game =1, 
g.pub_id = p.id_pub, 
g.dev_id = d.id_dev, 
g.type_id = gt.id_type

Anyone know why that doesn't work?

gorillaboy · #2 (**permalink**) 03-07-2005, 01:22 PM

Quote:

Originally Posted by TeKBuzz

Ok, I haven't done mysql in a while and someone will yell at me for not realizing why this is wrong but...

Code:

SELECT * FROM 
games AS g, 
game_types AS gt, 
publishers AS p, 
developers AS d
WHERE 
g.id_game =1, 
g.pub_id = p.id_pub, 
g.dev_id = d.id_dev, 
g.type_id = gt.id_type

Anyone know why that doesn't work?

Don't you need a semi colon? ;