|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
SQL Query help
Hi there, i need help with sql
I have 4 tables, UserTab(Id, Name, Email, Phone) ItemTab(ItemId, Type, Item) relationTab(Id, TransactionId, ItemId, Quantity, ReturnedDate, ReceiverId) loanTab(Id, TransId, BorrowerId, DateBorrowed, IssuerId, ReceiverId) I wanna do a search for employee and return the items tht the employee borrowed. Whats wrong with my sql statement ? SELECT UserTab.Name, ItemTab.Item FROM LoanTab INNER JOIN UserTab ON LoanTab.ReceiverId = UserTab.Id INNER JOIN relationTab ON LoanTab.TransId = relationTab.TransactionId INNER JOIN ItemTab ON relationTab.ItemId = ItemTab.ItemId WHERE Name LIKE '%strName%' <hr> I tried doing this in the query analyzer it displayed the fields but no entries.. Pls help, thanks in advance |
|
#2
|
||||
|
||||
|
Quote:
Try this: Code:
SELECT UserTab.name, ItemTab.Item FROM UserTab, ItemTab, relationTab, loanTab WHERE relationTab.ItemId = ItemTab.ItemId AND LoanTab.TransId = relationTab.TransactionId AND UserTab.Id=relationTab.Id AND UserTab.name Like '%strName%' |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > SQL Query help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|