By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,709 Members | 2,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,709 IT Pros & Developers. It's quick & easy.

Selecting data from three tables with a many-to-many relationship

P: 1
hi ,
i have a problem in retrieving data from database.
i have let us say 3 tables like:

super(id) -- id is the primary key
items(id,itemid,created date,otherdetaile)

id is foreign key in both profile and items.

profile has id only once.
but items can have it as many times it can.(like one to many relation)

now i need to retrieve all the profiles with only one item that was created at first by that id.
please help me in this query
Oct 15 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 5,821
Heya, haripriyavemula. Welcome to TSDN!

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).
Oct 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.