Go to Post You pick the best person for the job whether they are black, white, asian, hispanic, female, or male; NOT so you 'look good' when they publish your team picture in the school paper, but because they can get the job done right, on time, with a passion. - Pavan Dave [more]
Home
Go Back   Chief Delphi > Technical > Programming
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Spotlight this post!  
Unread 07-06-2007, 03:18
i2ppl i2ppl is offline
Registered User
no team
 
Join Date: Jun 2007
Location: Uzbekistan
Posts: 1
i2ppl is an unknown quantity at this point
Can i output combined query to DBGrid or DBEhlibGrid

Hello friends!
I need your help in this case.

I've 2 tables: table1(id, id_bookname) and table2(id, id_bookname, bookname).

table1's `id_bookname` consists table2's integer `id_bookname`'s values.

Can i output combined query to DBGrid or DBEhlibGrid which contains table1's `id` and table2's `bookname`.

For instanse,

table1
id id_bookname
------------------------------
1 134
2 532
3 134
4 134
5 532

table2
id id_bookname bookname
-----------------------------------------------------
1 134 book1
2 532 book2

Results in DBGrid must be:
id bookname
---------------------------
1 book1
2 book2
3 book1
4 book1
5 book2
 


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

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

vB 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
Calculus Query phrontist Math and Science 36 01-11-2005 20:24
Delhpi Program Query sunil bansal Programming 4 04-02-2005 00:22
Member Query Tytus Gerrish CD Forum Support 9 02-12-2003 20:09
MySQL query question Jack Website Design/Showcase 9 02-02-2003 00:11
Can I drill the output shafts of unmodifiable motors? archiver 2001 4 23-06-2002 23:08


All times are GMT -5. The time now is 00:24.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi