[homer.favenir]

i have a db, with 6 tables, when i link them or join them the output is blank.

i made my db in xampp.each table as primary key.

but when i executed the output it was blank.

what seems to be the problem? is it my table or the primary key? or link?

please advise..

thanks

[r937]

let's start with the query

could we see that please?

[homer.favenir]

Originally Posted by r937

let's start with the query

could we see that please?

SELECT
production.Directory,
production.Filename,
filename.`Total Lists`
FROM
production
INNER JOIN filename ON (production.prodid = filename.prodid)

thanks

[r937]

looks perfect

could you please do a SHOW CREATE TABLE for each of them

[homer.favenir]

Originally Posted by r937

looks perfect

could you please do a SHOW CREATE TABLE for each of them

i have my DB in xampp, and i run it in phpmaker and i make report in crystal report.

$sql = 'SELECT * FROM `production` LIMIT 0, 30 ';

thanks

[homer.favenir]

this is my db
pls see attached file.

i dont understand what seems to be wrong...i keep on trying to analyze this but i dont know the reason.

BTW i like your academy.

thanks

[Coach4u]

try changing the it to this
INNER JOIN filename ON (production.prodid < filename.prodid)
or
INNER JOIN filename ON (production.prodid > filename.prodid)
if it works, it not finding the same prodid

[homer.favenir]

nope, it didnt work, it is just keep on repeating...
i am using xampp and phpmaker for making php and sql.

my primary key is not index.
do i need to make it index?

thanks