remember to use the proper alias for the where clause too