PHP expert |
|
Dit moet werken.
SELECT COUNT( DISTINCT table1.userid ) AS tbl1_length, COUNT( DISTINCT table2.userid ) AS tbl2_length
FROM table1, table2
SELECT COUNT( DISTINCT table1.userid ) AS tbl1_length, COUNT( DISTINCT table2.userid ) AS tbl2_length FROM table1, table2
Edit -> Bedoel je dit hieronder?
SELECT COUNT(DISTINCT table1.userid ) + COUNT(DISTINCT table2.userid) AS optellen
FROM table1, table2
SELECT COUNT(DISTINCT table1.userid ) + COUNT(DISTINCT table2.userid) AS optellen FROM table1, table2
|