[Last Call] Learn how to a build a cloud-first strategyRegister Now

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

How to make SQL querryes. Need example!

Hello!
For example I have Paradox databases main.db and words.db...
main.db fields: 1) Id; 2)name; 3)surname
words.db fields: 1)Id; 2)word
All fields are 'string'.
Please, give me example, how I can make FIND procedure in
SQL for those tables. I need to get working application. And also I need to get short description about SQL sintaxis.
Thanx...

0
hind
Asked:
hind
  • 4
  • 2
1 Solution
 
mriderCommented:
select * from "main.db" where
name like "%some%"
// for substring search
//or
select * from "main.db" where
name  "some"
//for string search
good book on SQL is Martin Gruber "Understanding SQL"


0
 
hindAuthor Commented:
Very nice... But tell me plsss, where I can read results of search? (about DBGrid with datasource:=query I know)... But may be there are more things?
0
 
mriderCommented:
look at page Database Controls in your Delphi. Almost all of this components can show results

0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
mriderCommented:
look at page Database Controls in your Delphi. Almost all of this components can show results

0
 
hindAuthor Commented:
And the last question... :]
I have Paradox databases main.db and words.db...
    main.db fields: 1) Id; 2)name; 3)surname
    words.db fields: 1)Id; 2)word
    All fields are 'string'.
I want to make select from main.db and words.db for all equal
id from main.db and words.db, and for name='dima'...
It's the last question :)
0
 
mriderCommented:
first - you have _tables_, not database. database is data and relations.
try use
select a.*,b.* from "main.db" a, "words.db" b
where
 b.id=a.id
 and a.name="dima"

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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