Limit a Left Join on the first table Limit a Left Join on the first table sql sql

Limit a Left Join on the first table


sql left-join limit

Something like that

   SELECT * FROM A      INNER JOIN ( SELECT * FROM A WHERE A.FIELD1='X' ORDER BY A.FIELD2 LIMIT 10) X             ON (A.KEYFIELD=X.KEYFIELD)      LEFT JOIN B ON (A.FIELD = B.FIELD)      LEFT JOIN C ON (A.FIELD = C.FIELD)

sql left-join limit

Try this:

SELECT g.gemid, g.title, r.tot, gemdetail.filenameFROM (SELECT * FROM gems WHERE grade = '7' LIMIT 10) gLEFT JOIN (SELECT gemid, COUNT(*) AS tot FROM gemreply GROUP BY gemid) r          ON r.gemid = g.gemidLEFT JOIN gemdetail ON g.gemid = gemdetail.gemidLEFT JOIN users ON g.userid = users.useridORDER BY g.gemid;

This should work.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last