Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Relational Databases
Expertise: Beginner
Oct 30, 1998

SQL Joins with Paradox

Question:
I'm developing a program that lists all of a shop's clients and the items that they purchased. The problem is that if some clients haven't bought anything, they don't appear. I would like to perform a left join (like in Access) with Paradox. However, I don't know Paradox and the BDE well enough. Can you please help me?

Answer:
Paradox and the BDE use a subset of ANSI SQL called LocalSQL. However, I should note that after Delphi 3, the BDE is completely ANSI SQL compliant. To do a left outer join on two tables, you'd do something like this:

SELECT D.ClientID, D.ClientName , D1.*
FROM "TABLE1.DB" D LEFT OUTER JOIN "TABLE2.DB" D1 
WHERE (D1.ClientID = D.ClientID)
That's it! It's more of syntactical thing than anything else.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap