Very simple table design question

[johnn]

Hi,

Say I have a table that contains:

username
password
fielda
fieldb
...
...
fieldx

if I make query to select only username and password and join with several other tables, should I better make a separate table that contain only password and username? Is it more efficient?

Thanks,
JOhn

[eddiembabaali]

userid , username, password seems more efficient then you can always use userid to join to other tables

[johnn]

Thanks eddiembabaali, so you recommend making userid , username, password as a separate table?

[eddiembabaali]

Yes thats what I recommend. I have always used this set up and its never let me down occasional I add a field for permissions (admin, normal, whatever).

Make it separate table by all means.