As in the JOIN to limit the data in one table?

Is the following query:
 catg AS c
 RIGHT JOIN gallery AS p ON (p.cid = p.catid)

How to make limiting that would be for display only cid S. 1 p.catid choose 1 of gallery 1 of catg.
September 18th 19 at 23:58
2 answers
September 19th 19 at 00:00
Valid - in any way.
Specifically for mysql, you can do bad code using group by primary key categories, in this case in the fields of the gallery will return a random tuple from a gallery. But this behavior depends on the status of the Directive ONLY_FULL_GROUP_BY which all normal people include, prohibiting the obscenity.
September 19th 19 at 00:02
well, for example the group by.
That's all you can answer such a vague and a set of incorrect assumptions in the question.

Find more questions by tags MySQLPHP