Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!216.196.98.142.MISMATCH!border3.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From: beboprich@gmail.com
Newsgroups: comp.databases.xbase.codebase
Subject: relations codebase
Date: Tue, 10 Jul 2012 09:54:39 -0700 (PDT)
Organization: http://groups.google.com
Lines: 28
Message-ID: <8fe99ec4-8a8b-4ef6-9657-bc68ca8bbc97@googlegroups.com>
NNTP-Posting-Host: 189.225.41.247
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1341944184 5902 127.0.0.1 (10 Jul 2012 18:16:24 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 10 Jul 2012 18:16:24 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=189.225.41.247; posting-account=bB39NAoAAABNkARitqh5Pm-LoM4j0WcI
User-Agent: G2/1.0
Xref: csiph.com comp.databases.xbase.codebase:9

We've a doubt about using relations in codebase:

We have a relationship between a couple of tables, Producto and PromocionSu=
cursal. Into Producto we have a complete serie of records (about 23,000). I=
nto PromocionSucursal we only have part of those records (6,300 records). I=
n Transact SQL to get all the records of table Producto and also to know wh=
ich of them have a relationship with ProductoSucursal, we execute the next =
script:

Select p.idProducto, ps.idPromocion=20
From Producto p, PromocionSucursal ps
Where p.idPRoducto  *=3D ps.idPRoducto
And ps.idSucursal =3D 1

If we don't use the operator *=3D  in this script, we only get the 6,300 re=
cords we have into the table PromocionSucursal.=20
Using the operator *=3D we get 23,000 records, some of them comes with null=
 values on the field idPromocion that implies that those records has not re=
lation.

In code base we don=B4t know how to reply the same behavior, I mean, to use=
 two different tables and make a join to recover all values with the same s=
cript, considering that one of the tables are not going to have all world o=
f records that we have in the other.

We appreciate any suggestions.

Regards