By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 748 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 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
profile(id,name,..otherdetails)
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


pbmods
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.