FAQ |
Kalender |
|
![]() |
#1 | ||
|
|||
Nykomling
|
Ta bort grupperingen. Den borde ej behövas i den query'n?
|
||
![]() |
![]() |
![]() |
#2 | ||
|
|||
Nykomling
|
Om customers endast kommer returnera en rad så bör ju denna fungera:
Kod:
SELECT c.*, (SELECT COUNT(*) FROM Followers AS f WHERE f.accountNo = c.accountNo) AS followers FROM Customer c INNER JOIN OptInChannels o ON c.accountNo=o.accountNo WHERE c.accountNo = '907286609046' |
||
![]() |
![]() |
Svara |
|
|