PDO fetchall() strange behaviour

Hello,

I have a simple query but when I add a INNER JOIN it seems to double up on the results retued:

Code:

SELECT * FROM mytablename WHERE id=1

Works and retus two results as expected.

But:

Code:

SELECT A.*, B.* FROM mytablename as A INNER JOIN mysecondtable AS B ON (A.id=B.id) WHERE A.id=1

retus 4 results?

Any idea what I am doing wrong and how to resolve the issue?

برچسب: نویسنده: آیلین رضوانی تاريخ: سه شنبه 12 دی 1396 ساعت: 13:37