• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • Last Modified:

right join in a querry

I write a Delphi 1 programm (using BDE 2.52)
that use this SQL :
select A.F1, B.F2 from A right join N on A.F2 = B.F2
where A.F1 = 100
and it works fine
When I try to use this SQL in Delphi 3 (using BDE 4.0)
does not work
Can you help me ?
0
odan
Asked:
odan
  • 3
1 Solution
 
pjdbCommented:
I should be

select A.F1, B.F2 from A right join B on (A.F2 = B.F2) where (A.F1 = 100)

JDB
0
 
pjdbCommented:
On the first line, read "It should be" and not i ;-)

JDB
0
 
pjdbCommented:
Odan, Is it working?

JDB
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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