Karen
|
| Posted: 06/08/2003, 8:58 PM |
|
I'm using CCS. In my grid, I have 2 fields (owner and updated by) linked to the user id. Therefore, I have added the user table twice in the query builder with left join to the owner and updated by respectively. However, I'm not getting any results for one of the columns, it is blank. Am I doing this the correct way?
Pls help. TIA!
|
|
|
 |
RonB
|
| Posted: 06/09/2003, 2:23 AM |
|
in the query builder select the table holding user_id twice. CCS will automatically create an alias for the second table. Now make seoerate joins to the two tabels.
RonB
|
|
|
|
Karen
|
| Posted: 06/09/2003, 5:43 PM |
|
I did select the table twice and an alias was created for the second one but the results don't show for the first join. Very strange... Any idea why?
|
|
|
|
Karen
|
| Posted: 06/09/2003, 8:01 PM |
|
So, so, sorry! My mistake. It does work. I did not refresh the drop-down list and select again after adding the second table since the field names are now aliased. So it was trying to display a non-existent field...
Thanx for all the help!
|
|
|
|
|
