All Questions
2 questions
4
votes
2
answers
3k
views
Outer self join filters vs subqueries
I have a table storing information about tickets. There is one record when ticket is sold and another when ticket is used. There is a column called TransType which is set to either 'sold' or 'used' ...
- 238
2
votes
1
answer
882
views
Update only the oldest entry in a table with foreign key criteria
I'm working on a forum website.
What I am trying to do is updating the thread Title and Content (first post), which resides in different tables - "Threads" and "Posts".
"Threads"
"Posts"
I'm not ...
- 23