- Local time
- Today, 01:17
- Joined
- Aug 30, 2003
- Messages
- 36,275
No; a UNION has a different structure, and does a different thing:
SELECT...
FROM...
UNION ALL
SELECT...
FROM...
Basically it's going to stack those records vertically, while a JOIN will put them horizontally. Knowing what you expect to see will help us choose the right one.
SELECT...
FROM...
UNION ALL
SELECT...
FROM...
Basically it's going to stack those records vertically, while a JOIN will put them horizontally. Knowing what you expect to see will help us choose the right one.