Monday, 26 August 2013

Progress 4GL queries

Progress 4GL queries

I am new to this language and having some problems understand queries.
for example:
There are 2 database tables: Warehouse, product. So each warehouse can
have multiple products and products can be stored in different warehouses.
Query:
for each warehouse,
each product:
display warehouse.name, product.prodcode.
end.
the display will like
warehousename productcode awarehouse SKA-301
so for this result, are these columns display total independent result,
eg. SKA-301 product may not in awarehouse. Or it will display the product
in awarehouse? what if product and warehouse don't have related fields?
Please help me. Thank you.

No comments:

Post a Comment