query

[dave]

Hi
I'm generating one report from one query...I am confused how to write sql
for query..
I have two table one is Customer (Id,Name,Country)
Another table is CustomerPwd (Id,CustomerId,PwdType,Password)

Lets say I have data in Customer Table like this

ID Name Country
1 John Australia
2 Nick USA

In CustomerPwd I have always two records for each records...

Id CustomerId PwdType Password
1 1 Principle 0012
2 1 Staff 0013
3 2 Principle 1102
3 2 Staff 1023

Now I want query out put something like this...

ID Name Country PrinciplePWD StaffPWD
1 John Australia 0012 0013
2 Nick USA 1102 1023

Can any one suggest me how to write SQL to get output like this....

Any help would be appreciated...
Thanx

 

[PC Datasheet]

Create a new query using the query wizard. Include both tables in the query.

 

[Duane Hookom]

.... and make the query into a Crosstab Query.