Programming Forums
User Name Password Register
 

RSS Feed
FORUM INDEX | TODAY'S POSTS | UNANSWERED THREADS | ADVANCED SEARCH

Reply
 
Thread Tools Display Modes
Old Jul 3rd, 2009, 3:58 AM   #1
Mary Claire
Newbie
 
Join Date: Jul 2009
Posts: 2
Rep Power: 0 Mary Claire is on a distinguished road
How can i retrieve related records from the same table?

I am currently working on my SQL database and I am wondering whether I can retrieve related records from the same table or not. How can this be done? I'm afraid that all my records will be lost. Need help please.

Thanks in advance for any reply.
__________________
"Determination, hard work, and inspiration make a great mystery."
Bennetts and Bennetts Irongate Online Store - Derbyshire, UK.
Mary Claire is offline   Reply With Quote
Old Jul 3rd, 2009, 6:54 PM   #2
amragman
Genemesis
 
amragman's Avatar
 
Join Date: Jul 2009
Posts: 44
Rep Power: 0 amragman is on a distinguished road
Re: How can i retrieve related records from the same table?

Please elaborate on what sort of related records you want to retrieve???

In general to retrieve a record from SQL database we use Select statement along with where or like and other clauses.

I assume you know SQL!!
__________________
Genemesis
amragman is offline   Reply With Quote
Old Aug 30th, 2009, 10:03 PM   #3
parul1234
Hobbyist Programmer
 
Join Date: Jul 2009
Posts: 123
Rep Power: 0 parul1234 is an unknown quantity at this point
Re: How can i retrieve related records from the same table?

It is just a basic SQL query I am not sure why are you afraid that the data will be lost. Any way select doesnt delete anything from database
parul1234 is offline   Reply With Quote
Reply

Bookmarks

« Previous Thread in Forum | Next Thread in Forum »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
An Access records changing and sorting problem Vindicator Visual Basic 2 Jul 8th, 2009 11:10 PM
cloned dynamic table sandyssn Databases 0 Feb 11th, 2009 5:16 AM
Build a table like a grid or pivot table with dynamic columns kal326 Databases 0 Dec 17th, 2008 12:17 PM
mysql get last 10 records in a table kruptof Other Web Development Languages 3 Jun 29th, 2007 10:23 AM
comparing same table from 2 different .mdb files Roger Visual Basic 1 Jun 28th, 2005 5:46 PM




DaniWeb IT Discussion Community
All times are GMT -5. The time now is 12:35 PM.

Powered by vBulletin® Version 3.7.0, Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Copyright ©2007 DaniWeb® LLC