
December 17th, 2012, 08:58 PM
|
|
Registered User
|
|
Join Date: Dec 2012
Posts: 1
Time spent in forums: 12 m 13 sec
Reputation Power: 0
|
|
|
SQL Join -SQLite DB
I need help, i have 2 tables (ItemRegistration and ItemClassification)
ItemRegistration - Table 1
itemId,
itemName,
color,
itemClassificationId (FK)
ItemClassification - Table 2
itemClassificationId
itemClassificationName
Now i want to query result to display items under itemclassification in Table -1.
For example:
ItemNames = Apple iphone, Samsung Galaxy,LG
ItemClassification: Mobile and Gadgets
ItemNames = Samsung Smart, Sony
ItemClassification: TV
I have written bewlow query to display result in Item registration table
select DISTINCT ItemCode,ItemName,ItemClassification.[ItemClassificationName]
from ItemRegistration
left join ItemClassification on [ItemRegistration].[itemClassificationId]!=ItemClassification.[ItemClassificationCode];
Above query is not giving expected result.
Please correct me where i am missing. I am using SQLite DB and it doesn't support Full or right joins
|