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

Question

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

Is the following query:

SELECT 
*
FROM 
 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.

Marlon_McLaughlin asked September 18th 19 at 23:58

Related questions

More answers about "As in the JOIN to limit the data in one table?"

2 answers

tyrique.Rodriguez13 answered on 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.

daniella.McLaughl answered on · Accepted Answer · 2019-09-19T00:00:13.327Z

daniella.McLaughl answered on September 19th 19 at 00:00

Solution

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.