Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 158
  • Last Modified:

Retrieving data from related tables in codebase delphi

Hello,

Can anyone help me to create an application on Delphi and Codebase.
I need to select data from two tables like master and detail and i want to print both tables data together

I am having problem with relate two tables and retrive data from the relation.

If anyone have idea on this,  please explain. if it is possible with example

Thanking you,

Punitha.M.V.
0
sritharanb
Asked:
sritharanb
  • 2
1 Solution
 
kretzschmarCommented:
??
>and i want to print both tables data together


usual you could use a select like

select * from master, detail where master.id = detail.master_id

or if you have detailless masters

select * from master left outer join detail on master.id = detail.master_id

you should explain your needs more detailed

meikl ;-)
0
 
kretzschmarCommented:
just to reask about the c-grade

i advice you to read
http://www.experts-exchange.com/Programming/Programming_Languages/Delphi/help.jsp#hi73

meikl ;-)
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now