Article:  |
Types of JOINs | |
| Subject: | When To Use It? | |
| Date: | 2002-03-06 21:32:02 | |
| From: | abombss | |
|
We recently had a problem where we needed to bring back a recordset with a row for every day ( between a range ) and every employee, regardless if the employee had data for that date. In order to accomplish this I used a cartesian product. Half the staff thought I was crazy and was breaking every rule of SQL. I knidly pointed out that in certain situations, like this one, it was the easiest way to solve the problem, and the Cross Join is the most basic of all joins.
|
||
Women in Technology
Hear us Roar
