[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

where clause

Hello all,
I have 2 questions:
1-) What ddl_item_number != '.' mean in the where clause ?
2-) hdr_op_number is in a different table.  How come ddl_op_number =
&hdr_op_number in the where clause if there are not join for the table of
ddl_op_number and a table for &hdr_op_number ?


begin-select
count(ddl_item_number) &item_count
  print &item_count     (0,45,4)        edit 9999
from ddl
where ddl_op_number = &hdr_op_number
  and ddl_item_number != '.'
end-select

Any help will be greatly appreciated.
Thanks,
Heba