if only for ONE query for this display, 1 is A LITTLE better.

actually,2 needs DBMS to the execute the Select clause as 1.
But 1 does need to CREATE a view.

2(view) is better if considering the DB security, data independence, ETC.

所有跟帖： 

• (typo) But 1 does NOTneed to CREATE a view. -戏雨飞鹰- ♀ (0 bytes) () 10/10/2008 postreply 09:34:41