Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dealing with orphaned/absent rows in join
Here are my tables: Table1 Part_ID Part 1 Thing1 2 Thing2 3 Thing3 4 Thing4 5 Thing5 Table2 Part_ID Property_Name Property_Value 1 Size 5.5 1 Weight 101 2 Size 10.2 3 Size 11.1 3 Weight 75 4 Weight...- FrogmanL
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Dealing with orphaned/absent rows in join
I have a query with that joins two tables. One table contains a part and part_id, and another table contains property_name, property_value, and related part_id. The problem that I'm having is that every part may not have every property. If I join the part_id field, and select property_value...- FrogmanL
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
