BASIC join tables
Posted: Mon Nov 01, 2004 10:01 pm
Hi .
I am focusing a problem (with basic): mysql join tables. Since yesterday I reviewed a many posted answers regarding join tables, and mysql sources as well. Some how I did not found answer to my problem.
There are two tables, should “cooperate” together, but they don’t . LOL
Table one = Application:
apID ( INT)
apName (TEXT)
Table two=model:
mID (INT)
apID (INT)
the query : "SELECT * FROM model INNER JOIN application ON application.apID=model.apID
I expected to get: apID (numbers) - displayd in the “model” table but all what I got is only “0” . What am I doing wrong?
Thanks in advance
I am focusing a problem (with basic): mysql join tables. Since yesterday I reviewed a many posted answers regarding join tables, and mysql sources as well. Some how I did not found answer to my problem.
There are two tables, should “cooperate” together, but they don’t . LOL
Table one = Application:
apID ( INT)
apName (TEXT)
Table two=model:
mID (INT)
apID (INT)
the query : "SELECT * FROM model INNER JOIN application ON application.apID=model.apID
I expected to get: apID (numbers) - displayd in the “model” table but all what I got is only “0” . What am I doing wrong?
Thanks in advance