|
|
 |
|
|
Thread Tools | Display Modes |
Jul 3rd, 2009, 3:58 AM
|
#1 |
|
Newbie
Join Date: Jul 2009
Posts: 2
Rep Power: 0
 |
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. |
|
|
|
Jul 3rd, 2009, 6:54 PM
|
#2 |
|
Genemesis
Join Date: Jul 2009
Posts: 44
Rep Power: 0
|
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 |
|
|
|
|
Aug 30th, 2009, 10:03 PM
|
#3 |
|
Hobbyist Programmer
Join Date: Jul 2009
Posts: 123
Rep Power: 0
|
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
|
|
|
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Linear Mode
