Re: join question

Hi,

first of all I would like to suggest to put some effort in layout of your query. It makes reading it, and understanding it a whole lot easier. Second, if what your saying is correct, and I have no reason to doubt it, it can only mean one thing: the table PROSECUTION holds no records where FK_PROCEEDINGNUMBER0 = '7584867'.
Just do a simple select to check that.
As for the numbers of tables in your join, that's no problem at all.

Reinier.

<sumera.shaozab_at_lmco.com> wrote in message news:8rabfk$p3o$1_at_nnrp1.deja.com...
> Hello,
>
> Please help me find out what am I doing wrong. I have two select
> statements (slightly different) where one works and the other does not
> give me any results.
>
> This one works:
>
> select number0, p.role, p.identifier, p.fk_proceedingnumber0,
> z.ref_serial_number,z.fk_partyidentifier from proceeding, party p,
> property z where number0 = '7584867' and p.fk_proceedingn
> umber0 = '7584867' and z.fk_partyidentifier = p.identifier;
>
> This one does not work because I added another join statement:
>
> select number0, p.role, p.identifier, p.fk_proceedingnumber0,
> z.ref_serial_number, z.fk_partyidentifer, s.ENTRY_CODE,
> s.fk_proceedingnumber0 from proceeding, party p, property z, PROSECUTION
> s where number0 = '7584867' and p.fk_proceedingn
> umber0 = '7584867' and z.fk_partyidentifier = p.identifer and
> s.FK_PROCEEDINGNUMBER0 = '7584867';
>
> Does join have limits to how many tables I can join? Is there another
> way I can do the second statement?
>
> TIA
>
> SAS
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 03 2000 - 02:57:57 CDT