Tagged Questions
0
votes
2answers
61 views
Counting results for cross join
How I can get count results with cross join?
Example cross join:
SELECT t1.firstname, t2.lastname
FROM table1 t1 CROSS JOIN table1 t2
2
votes
2answers
85 views
Joining 4 tables and 2 counts
I have four tables.
UserMaster
----------
UserKey - PK
UserName
UserID - UNIQUE
UserLogTransaction
------------------
UserID - FK:UserMaster.UserID
LoginTime
LogoutTime
CallCenter
----------
...
2
votes
1answer
232 views
Postgres planer JOIN removal
I have two tables, one contains a lot of rarely update data, and one contains a little of frequently update data. Every record in second table has corresponding record in the first, like following:
...
