Select from multiple tables in asp.net

[acevedoamilcar]

lets say I have 2 Tables:\[code\]USER\[/code\]:

• \[code\]Userid\[/code\](PK),
• \[code\]FirstName\[/code\],
• \[code\]LastName\[/code\].

\[code\]ADDRESS\[/code\]:

• \[code\]Userid\[/code\](FK),
• \[code\]Street\[/code\],
• \[code\]City\[/code\].

Now I want to display following data in a \[code\]Table\[/code\]:\[code\]| userid | FirstName | LastName | Street | City \[/code\]i need to get all entries so it would be nice if i could store the information in a \[code\]List\[/code\] or something...