All Questions
3 questions
1
vote
1
answer
38
views
MySQL Tennis Ladder View Creation Question
I am creating a Tennis Ladder VIEW using MySQL and wish to do the following:
Properly create a view that includes: All player's names
These player names will come from the table: User - using the ...
- 21
0
votes
1
answer
42
views
Join two tables with similar columns
I hva two tables as is:
Table univers:
client
commercial
Axel
Tony
Mike
Jhon
Chris
Jhon
Table transactions
frclient
toclient
commission
Axel
NA
10
Mike
NA
8
NA
Mike
15
Axel
NA
4
NA
Chris
5
...
- 33
0
votes
1
answer
42
views
Using the correct JOIN
I am trying to create an app for the salespeople who work for my company to keep track of their sales/commission
When a salesperson brings on an account, their name is noted on the account and the ...
- 177