sql expression field
dear value expert
it's some about using crystal report in ASP.NET.
Let say, the application is perform on a private network by using browser as their medium.
the database architecture would be: retrieve the branch_address from the table branch_setup, each branch is specify with
branch_id (Primary key for table branch_setup). it's kinda of client/serer architecture that each branch (client) will send
data back to server.
eery branch of course hve thier own address, so let say if i want to print any report at branch A, then the branch address
for this branch will print on the report header.
problem is:
any solution on the query which can uniquely filter every branch with their own address? i think the combinations would be
since the branch_id is PK, then which mean i can doing filter with this field to get each unique Branch_id (represent each
branch) then get thier own address
i am stuck with queries......
select branch_address //desired field
from branch_setup //from the table
|