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

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

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

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

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

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