B4J Question MySql experts, a little help ...

marcick

Well-Known Member
Licensed User
Longtime User
May I abuse of the forum for this ? .....

I have a query that extract the total records stored from each ID in the month of may

B4X: 
SELECT ID, COUNT(*) as Count FROM records
WHERE MID(StoTime, 6,2)="05"
GROUP BY ID
ORDER BY Count ASC

And I obtain the correct result as in the picture.

Now, each ID has an owner that is inside another table "Owners" that has fields "ID" and "Owner"
I would like the result of the first query contains also the owner and not only the ID and Count.

I tried to understand how works UNION ad JOIN clauses but no success ...
 

Attachments

  • Cattura.JPG
    11.3 KB · Views: 255
Sort by date Sort by votes

marcick

Well-Known Member
Licensed User
Longtime User
found it ..

B4X: 
SELECT records.ID, COUNT(*) as Count, Owners.owner as Owner
FROM records
LEFT JOIN Owners ON records.ID=Owners.ID
WHERE MID(StoTime, 6,2)="05"
AND Sender="R"
GROUP BY ID
ORDER BY Count ASC
 
Upvote 0

marcick

Well-Known Member
Licensed User
Longtime User
Thank you, your two cents are always welcome
Sometimes it's not easy to find an answer in those good guides, because you should before guess "which function will do this job" and then you can study the function ...
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
B4J Question Caused by: java.lang.ClassNotFoundException: org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument$Factory
Replies
10
Views
7K
oldeast
L
  • Question
B4J Question [BANanoServer] [jRDC2]
Replies
1
Views
713
LJG
L
  • Question
B4J Question Need to include META-INF in additional jar
Replies
6
Views
1K
xulihang
  • Question
B4J Question [BANano] [SOLVED] How does one use the .RequestAnimationFrame?
Replies
1
Views
666
Mashiane
  • Article
B4J Tutorial [ABMaterial] Alternative lightweight charts
Replies
4
Views
4K
Mashiane
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…