join question

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 Mon Oct 02 2000 - 11:00:57 CDT