[SQL] about subselect

Hi, I make a subquery test at postgresql 7.3.3 and postgresql 8.0.3. I found that postgresql 8.0.3 can't do this, while at postgresql 7.0.3 it works quite well : create table temp_hasil2( nojob numeric, nik numeric, tanggal numeric, kdpt numeric, kdljr numeric ); create table ap012( nojob

Re: [SQL] about subselect

Louise Catherine [EMAIL PROTECTED] writes: I make a subquery test at postgresql 7.3.3 and postgresql 8.0.3. I found that postgresql 8.0.3 can't do this, while at postgresql 7.0.3 it works quite well : 7.3 says this: NOTICE: Adding missing FROM-clause entry in subquery for table temp_hasil2

Re: [SQL] about subselect

I guess there's no other way,except adding the table name one by one. Thank you very much, Louise Catherine. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end