"OUTER JOIN" Problem

[fdsouth]

I am trying to write a simple SQL SELECT statement for listing data pulled from two Pervasive.SQL tables.

Table 1 (Part Lot)
Fields: STK_68, SERIAL_68, LOTNUM_68...

Table 2 (Order Master)
Fields: LOTNUM_10, UDFKEY_10...

My SQL statment reads:

SELECT [SERIAL_68], [UDFKEY_10] FROM "Part Lot" LEFT OUTER JOIN "Order Master" ON [LOTNUM_68] = [LOTNUM_10] WHERE STK_68 IN ('SUBST614')

When I execute the statement, my computer hangs. If I remove the WHERE clause, I get an answer. What am I missing?

Also, without the WHERE clause I get repeated instances of [SERIAL_68]. If I add "SELECT DISTINCT", computer hangs.

Please help. At wits end.

 

[TomKane]

What version of p.sql are you using? Version 7 uses (+) to indicate outer joins instead of 'outer join' syntax.

 

[fdsouth]

I'm using SQL.2000i SP 4.

I think I worked my way through it though. Thanks