Hi pclfw
1º of all, Thanks a lot for helping.

You know, i pasted your sql code, and I got this error:

I think the cause is the SQL engine I use -> www.nexusdb.com

I could post the server,...

Hi guys
Lemme explain the situation in 2 lines:
DB Structure:
http://img133.echo.cx/img133/6610/dbstructure6hs.jpg

Client goes to computer shop. Shop has 1 or more NORMAL promotions (of the...