query
-
hi all i need to have a query that will retrieve two rows from one table for example : one table has two foreign key from one table ROWs of Tbl1 ------ 1) ID 2) UserId1 3) UserId2 what should i do?
select
[User].[FirstName],
[User].[LastName],
[User].[FirstName],
[User].[LastName]
From
Tbl1 Join User on [UserId1]=[User].[Id] or [UserId2]=[User].[Id];please help me immediately
-
hi all i need to have a query that will retrieve two rows from one table for example : one table has two foreign key from one table ROWs of Tbl1 ------ 1) ID 2) UserId1 3) UserId2 what should i do?
select
[User].[FirstName],
[User].[LastName],
[User].[FirstName],
[User].[LastName]
From
Tbl1 Join User on [UserId1]=[User].[Id] or [UserId2]=[User].[Id];please help me immediately
Join your User table 2 times 1 for UserID1 other for UserId2 Join User as b on [UserId1]=[b].[Id] Join User as c on [UserId1]=[c].[Id]
-
hi all i need to have a query that will retrieve two rows from one table for example : one table has two foreign key from one table ROWs of Tbl1 ------ 1) ID 2) UserId1 3) UserId2 what should i do?
select
[User].[FirstName],
[User].[LastName],
[User].[FirstName],
[User].[LastName]
From
Tbl1 Join User on [UserId1]=[User].[Id] or [UserId2]=[User].[Id];please help me immediately
Run profiler and see where the costs are!
Never underestimate the power of human stupidity RAH