Hi,
i want to retrive data from a table which has a composite primary key. This is the query
im using;
"select price from Item_size where primarykey='"+pk+"'"
But it does not work. Im using MS Access. can anyone help me!
coroll 0 Junior Poster in Training
KidRocker 3 Newbie Poster
select dept.DVID as dept_division
, dept.DPID as dept_id
, sect.SCID as section_id
, sect.SCNAME as section_name
, count(EMPNO) as staff_count
from DEPARTMENT
http://searchoracle.techtarget.com/answer/Retrieve-data-related-by-composite-key
Ancient Dragon 5,243 Achieved Level 70 Team Colleague Featured Poster
A composite key means the key consists of two or more fields.
"select price from item_size where field1 = "something" and field2 = "smethin else" and ..."
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.